您现在正在浏览：站长之家 >> 数据库 >> 详细内容

SQLServer数据库实用技术（46）

时间:2007-12-23 来源:不详作者:迈克DB

例7-16：更改orders 表的列p_id 名称为products_id
exec sp_rename 'orders.[p_id]', 'product_id', 'column'
运行结果如下：
Caution: Changing any part of an object name could break scripts and stored procedures.
The column was renamed to 'product_id'.

例7-17：更改orders 表的名称为p_orders。
exec sp_rename 'orders', 'p_orders''
运行结果如下：
Caution: Changing any part of an object name could break scripts and stored procedures.
The object was renamed to 'p_orders'.