Introduction
The CREATE TABLE statement is used create a new table in the database. A table definition consists of a list of columns, their types, and any integrity constraints.
Syntax
- CREATE TABLE tableName( [ColumnName1] [datatype1] [, [ColumnName2] [datatype2] ...] )
Parameters
Parameter | Details |
---|
tableName | The name of the table |
columns | Contains an 'enumeration' of all the columns that the table have. See Create a New Table for more details. |
Table names must be unique.