Create, Alter, Drop or Delete SQL Server Table

This article will show you how you can create, alter and delete a table in sql server. So in this will show you how you can perform create, alter and delete table with wizard and by using query.

Create Table:

Syntax:

CREATE TABLE TableName (     Column1 DataType,     Column2 DataType,     Column3 DataType,     Column4 DataType,        .        .        .        .     ColumnN DataType );

Example:

CREATE TABLE Student (     Id int,     Name VarChar(50),     Address Varchar(50)        Marks int, );

The above will create a table with name of Student.

Alter Table:

Syntax:

ALTER TABLE TableName ADD ColunName DataType;

Above Query will help us to alter the table column. This will add a new column in the database table

Example:

ALTER TABLE Student ADD Section Varchar(50);

Drop Table:

Syntax:

Drop Table TableName;

Example:

Drop Table Student;

O/P:

Thank you please let me know your valuable comment.

YouTube Video: