A statement that creates a table with column attributes : Create Table « Table « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Table
  3. Create Table
4>
5> CREATE TABLE Billings
6> (BillingID      INT   NOT NULL IDENTITY PRIMARY KEY,
7> BankerID        INT   NOT NULL,
8> BillingDate     SMALLDATETIME NULL,
9> BillingTotal    MONEY NULL DEFAULT 0)
10> GO
1>
2> drop table Billings;
3> GO








3.1.Create Table
3.1.1.The basic syntax of the CREATE TABLE statement
3.1.2.PRIMARY KEY column
3.1.3.Table Creation Script for Parent and Child with FOREIGN KEY Constraint and INSTEAD OF Trigger
3.1.4.Computational column
3.1.5.CLUSTERED column
3.1.6.A statement that creates a table with column attributes