Syntax to create table in MSSQl Server2008
CREATE TABLE table
[name](
Column1,
Column2,
Column3)
Example

Customers  is the name of table.

CREATE TABLE Customers (
DrvLicNbr nvarchar(32),
DateIssued DATE,
DateExpired date,
FullName nvarchar(50),
Address NVARCHAR(120),
City NvarChar(40),
State NVarChar(50),
PostalCode nvarchar(20),
HomePhone nvarchar(20),
 OrganDonor BIT
);
 

 

  Modified On Nov-20-2017 04:05:51 AM

Leave Comment