By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,364 Members | 1,341 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,364 IT Pros & Developers. It's quick & easy.

How can i change the column name?

P: 40
1) Can somebody tell me How can V change the column name?

2) When you first load SQL SERVER you will startup with what
all databases?
I think Master database. But they have ask databases ?? Which more databases are loaded.
Apr 19 '08 #1
Share this Question
Share on Google+
3 Replies


P: 44
1) Can somebody tell me How can V change the column name?

2) When you first load SQL SERVER you will startup with what
all databases?
I think Master database. But they have ask databases ?? Which more databases are loaded.
1) SP_Rename can be used for doing so.

2) I guess what you want to ask is that what are the databases that come by default? 4 - Master, Model, msdb, tempdb. Refer to SQL books online for more info
Apr 19 '08 #2

P: 40
hey siva Can we AS Keyword in place of sp_rename . AS is also used for rename operation.
Apr 19 '08 #3

P: 44
Yes you are correct. It can used to rename the column name during SELECT statements only. If you want to permanently change the database column name you can go for SP_RENAME.
Apr 21 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.