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.
| Author |
Topic |
|
nauroz
Starting Member
1 Post |
 Posted - 2011-02-18 : 14:50:49
|
| Hi readers, I am new to SQL programming. Can I change the name of an existing column in a table ?Q2) Can I delete a column in a table ?Any help would be appreciated.Thank You |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-18 : 14:55:25
|
| yes. in SSMS right click on the table and select Design Mode add/remove/modify the name of the column and then save it .. thats all .. or for SQL command google "Transact SQL Alter table"Cheers! |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-02-18 : 15:10:19
|
| There's also the sp_rename procedure, you can rename pretty much anything with it. It's documented in Books Online. |
|
|
|
|
|
|
changing the name of column in SQL