SQL - CREATE Table
SQL - CREATE Table
Creating a basic table involves naming the table and defining its columns and each column's data type.The SQL CREATE TABLE statement is used to create a new table.
Syntax
CREATE TABLE table_name(
column1 datatype,
column2 datatype,
.....
columnN datatype,
PRIMARY KEY( one or more columns )
);
Then in brackets comes the list defining each column in the table and what sort of data type it is. The syntax becomes clearer with an example below.
A copy of an existing table can be created using a combination of the CREATE TABLE statement and the SELECT statement.
Read more.
Login in to like
Login in to comment