This video discusses how to manage tables in a relational database. The commands covered are
and TRUNCATE TABLE. After you finish watching this video, you'll be able to perform basic table management in a relational database.
Embed this video using the code below
In this tutorial, we look at how to use SQL to manage database tables. Before we dive into the specific commands, let us first go through the basics of a relational database.
In a relational database, data is stored in tables. Each table has a table name. A table consists of columns and rows. Each column is a field in a record, and there is a column name associated with each column. Each row represents one record. Usually when we say how many records we have, we are referring to the number of rows. With this information, now we are ready to look at how to use SQL to manage database tables.
The first thing we need to do before we can store any data in a relational database is to create a table that can store data. The SQL command for this is CREATE TABLE. The syntax for CREATE TABLE is