Answers for "mssql rename table name"

tsql rename table

-- SQL SERVER -- don't put the schema in the 'new_name' field, otherwise your table might end up looking something like schema.schema.new_name
EXEC sp_rename 'schema.old_name', 'new_name';

tsql rename column name

sp_rename 'table_name.old_column_name', 'new_column_name', 'COLUMN';