Renaming a Table or Its Columns

Use sp_rename to rename a table or column.

After renaming a table or any of its columns, use sp_depends to determine which procedures, triggers, and views depend on the table, and redefine these objects.

Warning!   If you do not redefine these dependent objects, they no longer work after the SAP ASE server recompiles them.