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

Quote:

Originally Posted by 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.

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.

How can i change the column name?

re: How can i change the column name?

re: How can i change the column name?

re: How can i change the column name?

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about