COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
ALTER TABLE
|
|
|
MODIFY TABLE
|
|
|
CHANGE TABLE
|
|
|
All of the Mentioned
|
Detailed explanation-1: -Answer: Explanation: In SQL, ALTER TABLE command is used to change a tables storage characteristics. It helps to add or delete columns, create or destroy indexes, change the type of existing columns, or rename columns or the table itself.
Detailed explanation-2: -Existing tables can be altered with an ALTER TABLE statement.
Detailed explanation-3: -The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. The ALTER TABLE statement is also used to add and drop various constraints on an existing table.
Detailed explanation-4: -The ALTER command in SQL is used to make changes to a table, view, or the entire database. We can add, modify, and drop constraints, columns, and indexes using the ALTER command in SQL.