To rename a table, execute sp_rename (do not rename the system tables). For information about a table and its columns, use sp_help. For information about integrity constraints (unique, primary key, references, and check) or the default clause, see create table.