Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
Dec 14, 2017

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


The sp rename SQL Stored Procedure

You can not use the ALTER TABLE statement in SQL Server to rename a column in a table. You can however, use the sp_rename stored procedure if you do not want to drop and recreate the table again.

Listing 1. Here is an example of the sp_rename syntax

sp_rename 'TABLE.OLD_COLUMN_NAME', 'NEW_COLUMN_NAME', 'COLUMN';
Hannes du Preez
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date