Change the Column Name in table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Change the Column Name in table

Author

Topic

chetancool
Starting Member

34 Posts

Posted - 2005-07-15 : 03:15:16

Hi,

I used to change the column name in table through enterprise manager.
Offlate, i tried to do through query analyzer.
i checked in BOL but unable to put the exact query.

Help please.

Thanks,
Chetna

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2005-07-15 : 03:25:27

Look up sp_rename in BOL

Andy

Beauty is in the eyes of the beerholder

chetancool
Starting Member

34 Posts

Posted - 2005-07-15 : 03:35:37

Thanks.. it worked.

cjain

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources