How can i change the column name?

[Yogesh Sharma]

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.

[siva538]

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

[Yogesh Sharma]

hey siva Can we AS Keyword in place of sp_rename . AS is also used for rename operation.

[siva538]

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.