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 |
|
putane.sanjay
Yak Posting Veteran
77 Posts |
 Posted - 2007-01-03 : 09:04:32
|
| Hi How to find how many columns in the table through tsqlplease suggest me |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-03 : 09:22:00
|
Ever heard of INFORMATION_SCHEMA views?select count(*) from information_schema.columns where table_name = 'tbl1' Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
putane.sanjay
Yak Posting Veteran
77 Posts |
Posted - 2007-01-04 : 05:23:41
|
| IAM NEW TO SQL DBAThank u |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-01-06 : 02:20:41
|
| orsp_columns 'TableName'MadhivananFailing to plan is Planning to fail |
|
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2007-01-06 : 11:48:16
|
| Putane,Just a thought... "New to SQL" and "DBA" are mutually exclusive terms and will set YOU up for less probability of success than the intersection of two very large random numbers... If you call yourself a DBA, people will really put you on the spot and you will very quickly get in over your head. "DBA" is not a simple term for anyone working with SQL.--Jeff Moden |
|
|
|
|
|
|
get columns