To create tblPerson table, graphically, using SQL Server Management Studio
1. Right click on Tables folder
2. Select New Table
3. Fill Column Name, Data Type and Allow Nulls, as shown below and save the table as
tblPerson
Sql Querey:
CREATE TABLE [dbo].[tblPerson](
PersonID int NOT NULL,
Name varchar(50) NOT NULL,
Dept varchar(10) NULL,
Mobile varchar(10) NULL
)
1. Right click on Tables folder
2. Select New Table
3. Fill Column Name, Data Type and Allow Nulls, as shown below and save the table as
tblPerson
Sql Querey:
CREATE TABLE [dbo].[tblPerson](
PersonID int NOT NULL,
Name varchar(50) NOT NULL,
Dept varchar(10) NULL,
Mobile varchar(10) NULL
)
No comments :
Post a Comment