RENAME Renames a database object, such as a database, a table, or a column. The syntax is: Syntax RENAME [Old name] [New name] Parameters Old name Defines a current name of a database, a table, or a column in the following format: [Database].[Table].[Column] New name Defines a new name of a database, a table, or a column in the following format: [Database].[Table].[Column] Rename is shown in Figure 5-46. Figure 5-46 Renaming a column Note, you must synchronize the database and set the privileges after you run the Rename instruction in order to see the database changes.
