文件名称：改变一个对象的名称-SQL语言基础
文件大小：5.26MB
文件格式：PPT
更新时间：2024-05-15 13:25:09
SQL 基础
改变一个对象的名称 * SQL> RENAME dept TO department; Table renamed. 更改表、视图、同义词、序列等对象的名称,执行RENAME 命令就可以了. 操作用户必须是对象的拥有者. * Renaming a Table Additional DDL statements include the RENAME statement, which is used to rename a table, view, sequence, or a synonym. Syntax RENAME old_name TO new_name; where: old_name is the old name of the table, view, sequence, or synonym new_name is the new name of the table, view, sequence, or synonym You must be the owner of the object that you rename.