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.

Rename a Table: Correct SQL Command for 'Product' to 'Items'

原文地址: https://www.cveoy.top/t/topic/nwQ8 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录