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.

Add batch/multiple posts to Facebook Page – Graph API

Using Facebook API to post articles from PHP

Check if Function Exists in Javascript

AbstractSureFireMojo Class Missing Maven Surefire

Redirect to home page on 404 – htaccess

Spring Data error: getOutputStream() has already been called for this response

Leave a Reply

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

*
*