Create Tables Part 3

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
)