Renaming Tables and Columns in SQL Server

Renaming Tables and Columns in SQL Server

Changing table or colum in SQL Server is as follows,
To change the name of the table:
sp_RENAME ‘tbloldname’, ‘tblnewname’;
To chagne the name of the column:
sp_RENAME ‘tbl.columnoldname’,’columnnewname’,’COLUMN’;

** You might face a problem on changing names of enforced (integrity) columns.

random files from directory

psql select not working

postgres not null to null

custom spring validator

facebook page post from PHP

spring boot validation

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*