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 |
|
matrixmind
Starting Member
9 Posts |
 Posted - 2010-02-01 : 01:42:25
|
| I have a table whice have 4 columns.And After alter that table have 7 columns.Then how to get add columns Name from that table.. ???????if any one know the answer Plz send it as soon as possible.............Dinesh SharmaMatrix SolutionSr.Software Engg. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-02-01 : 01:46:42
|
Try this as an approach:select * from sys.columns where Object_ID = Object_ID(N'DB..Table')
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-01 : 04:05:43
|
quote:
Originally posted by matrixmind
I have a table whice have 4 columns.And After alter that table have 7 columns.Then how to get add columns Name from that table.. ???????if any one know the answer Plz send it as soon as possible.............Dinesh SharmaMatrix SolutionSr.Software Engg.
you mean you need newly added columns alone? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-02-01 : 04:11:22
|
quote:
Originally posted by webfred
Try this as an approach:select * from sys.columns where Object_ID = Object_ID(N'DB..Table')
No, you're never too old to Yak'n'Roll if you're too young to die.
Dont use system tables. Use Information_schema viewsMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Sql Query