Creating, Altering, and Deleting Tables in SQL

Creating a Table To create a table, use SQL’s CREATE TABLE statement. Creating a basic table involves naming the table and defining its columns and each column’s data type. The following is the basic syntax for creating a table: CREATE TABLE name_of_table ( name_of_column column_datatype ) CREATE TABLE is the keyword telling the database system what you want to do—in this case, you want to create a new table. The unique name or identifier for the table follows the CREATE TABLE statement. Then in brackets comes the list defining each...

read more