Sunday , January 26 2020
Home / SQL Server / SQL Server: 06 – ALTER and DROP Statement

SQL Server: 06 – ALTER and DROP Statement

ALTER Statement in SQL
To add a column in a table, use the following syntax:
ALTER TABLE table_name
ADD column_name datatype
To delete a column in a table, use the following syntax:
 ALTER TABLE table_name
DROP COLUMN column_name

 

About Faheem

Faheem
An adaptable and responsible Software Engineer, who enjoys working with computers and the opportunity to learn new skills and work with new technologies is particularly attractive to me.

Check Also

SQL Server: 03 – Complete Installation Of SQL-Server 2008 R2

Get Torrent File Of SQL Server 2008 R2

One comment

  1. Avatar

    GREAT WORK (y)
    PLEASE UPLOAD MORE TUTORIAL

Leave a Reply

Your email address will not be published.