This Language Commands are using to define,Modify & Drop on object of database from SQL server.

Create : Creating a new database or new table in SQL Server.

Step1 :- Create a new database in SQL server

Syntax :- Create database <DBname>;

ex :- Create database MYDB;

Step2 :- Select The required database From SQL Server.

Syntax :- Use <DB Name>;

ex :- Use MyDB;

Step3 :-Create new table in database

Syntax : – Create table <TableName>

(<ColumnName/><DT>[size],<Column Name2>

<DT>[size] —); — 1000 Columns

Ex :- Create Table Student (sid INT,sname char(10), sfee Decimal(6,2),

Age Tinyint);

Step3 :-Create new table in database

Syntax : – Create table <TableName>(<ColumnName/><DT[size],<Column Name2><DT>[size] —);

— 1000 Columns

Ex :- Create Table Student (sid INT,sname char(10), sfee Decimal(6,2),

Age Tinyint);

Step 4 : -To view the Structure of table

Syntax:-Sp-HELP <TableName>;

ex : – Sp_HELP Students;

Sp_HELP is predefined  stored procedure.