COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
DELETE COLUMN column ____ name;
|
|
|
DROP COLUMN column ____ name;
|
|
|
ALTER TABLE table ____ name DROP COLUMN column ____ name;
|
|
|
None is correct.
|
Detailed explanation-1: -Syntax. The syntax to drop a column in a table in MySQL (using the ALTER TABLE statement) is: ALTER TABLE table name DROP COLUMN column name; table name.
Detailed explanation-2: -First, write ALTER TABLE, followed by the name of the table you want to change (in our example, product ). Next add the DROP COLUMN clause, followed by the name of the column you want to remove (in our example, description ). This removes the column from the table, including any data stored in it.
Detailed explanation-3: -Step 1: Go to the Databases-> Tables menu and expand it. Step 2: Select the desired table and expand it. Step 3: Select the Columns and expand them. Step 4: Right-click on the column name you want to remove and choose the Delete option.
Detailed explanation-4: -In Object Explorer, right-click the table from which you want to delete columns and choose Design. Right-click the column you want to delete and choose Delete Column from the shortcut menu.