bing
Flat 10% & upto 50% off + 10% Cashback + Free additional Courses. Hurry up
×
UPTO
50%
OFF!
Intellipaat
Intellipaat

Alter Command in SQL

Alter command in SQL is used to add, delete, or modify columns in an existing table. Alter in SQL is will help to make changes in the existing columns like add columns or delete columns.

Watch this Alter Command in SQL Tutorial video

Alter Table Add Column

To add a column in an existing table.

ALTER TABLE table_name

ADD column_name datatype;

Alter Table Drop Column

To delete a column from a table.

ALTER TABLE table_name

DROP COLUMN column_name;

Example of Alter Query in SQL

In this example we will look at how to add a column “Year” in a Student_details table.

ALTER TABLE Student_details

ADD Year int;
Previous Next

Download Interview Questions asked by top MNCs in 2019?

"0 Responses on Alter Command in SQL - Alter Column - Alter Table"

    100% Secure Payments. All major credit & debit cards accepted Or Pay by Paypal.
    top

    Sales Offer

    Sign Up or Login to view the Free Alter Command in SQL - Alter Column - Alter Table.