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 |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2006-09-11 : 15:09:16
|
| How can I get my table structure (columns, their types, whether it s an Identity column) using T-SQLplsThanks you |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-11 : 15:11:20
|
| sp_help tablenamePeter LarssonHelsingborg, Sweden |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-12 : 01:51:45
|
| Or simply select tablename in QA and press Alt+F1 (Shortcut way!!)Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-09-13 : 09:27:44
|
| or make use of Information_schema.columns ViewMadhivananFailing to plan is Planning to fail |
|
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2006-09-14 : 13:49:40
|
| Hi Harsh Athalye, what do I select before I type Alt F1, because that only gives me info about the DB and not about one specific table Thanks guys for your help |
|
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-09-14 : 15:25:37
|
Like harsh said:quote:
simply select tablename in QA and press Alt+F1 (Shortcut way!!)
|
|
|
|
|
|
|
how 2 get the table structure using T-SQL