Home > DeveloperSection > Articles > Create Table in Microsoft SQL Server

Create Table in Microsoft SQL Server


Database Database 
Ratings:
0 Comment(s)
 2821  View(s)
Rate this:

How to Create Table in Microsoft SQL Server 2008


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

);

 


Don't want to miss updates? Please click the below button!

Follow MindStick