Rename a Table: Correct SQL Command for 'Product' to 'Items'
The correct SQL command to rename a table from 'Product' to 'Items' is:
B. Alter table Products rename to Items
Explanation:
The ALTER TABLE command is used to modify the structure of an existing table. The RENAME TO clause is used to change the name of the table. The syntax is as follows:
ALTER TABLE old_table_name RENAME TO new_table_name;
Example:
ALTER TABLE Products RENAME TO Items;
This command will rename the table 'Products' to 'Items'.
Important Note: The specific syntax may vary slightly depending on the database management system you are using.
原文地址: https://www.cveoy.top/t/topic/nwQ8 著作权归作者所有。请勿转载和采集!