connectseekers.com

Tuesday, 17 March 2020

Create, Alter, Drop or Delete SQL Server Table

3/17/2020 - By Pranav Singh 0


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: 




Tags:
About the Author

We are the group of people who are expertise in different Microsoft technology like Asp.Net,MVC,C#.Net,VB.Net,Windows Application,WPF,jQuery,Javascript,HTML. This blog is designed to share the knowledge.

Get Updates

Subscribe to our e-mail newsletter to receive updates.

Share This Post

0 comments:

Please let me know your view

Free Ebooks


About Us

We are the group of people who are expertise in different Microsoft technology like Asp.Net,MVC,C#.Net,VB.Net,Windows Application,WPF,jQuery,Javascript,HTML. This blog is designed to share the knowledge.

Contact Us

For writing article in this website please send request by your

GMAIL ID: dotnetpools@gmail.com

Bugs and Suggestions

As we all know that this website is for sharing knowledge and providing proper solution. So while reading the article is you find any bug or if you have any suggestion please mail us at contact@aspdotnet-pools.com.

Partners


Global Classified : Connectseekers.com
© 2014 aspdotnet-pools.com Designed by Bloggertheme9.
back to top