CREATE TABLE Customers (
CustomerID nchar (5) NOT NULL ,
CompanyName nvarchar (40) NOT NULL ,
ContactName nvarchar (30) NULL ,
ContactTitle nvarchar (30) NULL ,
Address nvarchar (60) NULL ,
City nvarchar (15) NULL ,
Region nvarchar (15) NULL ,
PostalCode nvarchar (10) NULL ,
Country nvarchar (15) NULL ,
Phone nvarchar (24) NULL ,
Fax nvarchar (24) NULL
)
This statement is quite simple, but it illustrates the basic table creation.
The
CREATE TABLE statement has the following syntax:
CREATE TABLE
tablename
