How to rename a table in SQL Server?
SQL Server(mssql) 테이블 이름 변경
To rename a table in SQL Server, use the sp_rename
command:
To rename a column:
sp_rename 'table_name.old_column_name', 'new_column_name' , 'COLUMN';
To rename a table:
sp_rename 'old_table_name','new_table_name';