Saturday, March 12, 2011

Rename Column Name


Before rename column name

Step 1: sp_rename 'alertclub.uname', 'username'

After excute this query one msg will come like this:

Caution: Changing any part of an object name could break scripts and stored procedures.

and open table
Step 2:  select * from alertclub

you will see that column name changed from uname to username

After Rename column name


No comments: