SQL Server- Syntax to create simple table

Note the syntax to create a very simple table with two colums for sql server! We can do much more while creating tables like applying constraints, allow NULLs or NOT NULLS etc.

USE <DataBaseName>


GO

CREATE TABLE <TableName>

(

ProductID  VARCHAR(25),

ProductName VARCHAR(25)

)

GO