COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The command to remove rows from a table ‘CUSTOMER’ is ____
|
DROP FROM CUSTOMER
|
|
UPDATE FROM CUSTOMER
|
|
REMOVE FROM CUSTOMER
|
|
DELETE FROM CUSTOMER WHERE
|
Explanation:
Detailed explanation-1: -To remove rows from a table, use the DELETE command. You can use the DELETE command to remove specific rows or all rows from a table. To delete rows, specify the table and an optional search condition (WHERE) that specifies which rows to delete.
Detailed explanation-2: -We can also use the TRUNCATE command to delete all the records from a table.
Detailed explanation-3: -The DROP TABLE statement is used to drop an existing table in a database.
There is 1 question to complete.