sybaseIQ重命名列名

Warning!  You must change appropriately the definition of any dependent object (procedures, functions, and views) on an object being renamed by sp_iqrename. The sp_iqrename procedure does not automatically update the definitions of dependent objects. You must change these definitions manually.

Description

The sp_iqrename stored procedure renames user-created tables, columns, indexes, constraints (unique, primary key, foreign key, and check), and functions.

 

If you attempt to rename an object with a name that is not unique for that type of object, sp_iqrename returns the message “Item already exists.”

 

sp_iqrename does not support renaming a view, a procedure, an event or a data type. The message “Feature not supported.” is returned by sp_iqrename, if you specify event or datatype as the object-type parameter.

 

You can also rename using the RENAME clause of the ALTER TABLE statement and ALTER INDEX statement.

sp_iqrename 'a.unknown_2','code',column

来自为知笔记(Wiz)

转载于:https://www.cnblogs.com/iathena/p/33d583e9916667b4fe8d5b03e9ddb2b5.html