CREATE

CREATE:
1. Create a table:
CREATE TABLE tablename(column1 int, column2 nvarchar(20), column3 money, column4 datetime())

Modifications:
1. To make column1 as a primary key
CREATE TABLE tablename(column1 int primary key, column2 nvarchar(20), column3 money, column4 datetime())



2. To make column1 as an auto increment column
CREATE TABLE tablename(column1 int IDENTITY(1,1) NOT NULL, column2 nvarchar(20), column3 money, column4 datetime())

Explaination:

1. CREATE TABLE is the keyword to create a table

2. int, money, nvarchar, datetime are the datatypes
3. NOT NULL means the column can not be empty for any row.