Data Definition Language (DDL)

Hi All,

Here i am explain DDL concept in Sql Server for beginners.

DDL:
Create,Alter,Drop,Truncate

Create
Its used to create a Database (or) Table
Syntax: Create Database <DatabaseName> // For Create a Database
Create Table <TableName> (<FiledName> <DataType>) //For Create a Table
(Ex: create table test (id int,sName varchar(20))

Alter
Its used to Add (or) Delete a Column in the Table
Syntax: Alter Table <TableName> Add <ColumnName> <DataType> //For Add a Column in a Table
Alter Table <TableName> Drop Column <ColumnName> //For Delete a Column in a Table

Drop
Its used to Delete a Database (or) Table
Syntax: Drop Database <Database Name> //For delete a database
Drop Table <Table Name> //For delete a Table from Database

Truncate
Its used to delete a Data's from a Table
Syntax: Truncate Table <Table Name> //For delete a data's from a table

This Syntax are useful to Sql Server beginners.

Cheers :)