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 |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2004-04-13 : 17:01:43
|
| 2.) How may I get a count on the column names in a table and 1.) The name of all the columns in the tableAll help appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-13 : 17:05:02
|
| 1) SELECT COUNT(*)FROM INFORMATION_SCHEMA.COLUMNSWHERE TABLE_NAME = 'TableNameGoesHere'2) SELECT COLUMN_NAMEFROM INFORMATION_SCHEMA.COLUMNSWHERE TABLE_NAME = 'TableNameGoesHere'ORDER BY ORDINAL_POSITIONTara |
 |
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-04-13 : 17:10:05
|
| Thanks much TAll help appreciated. |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-04-13 : 17:16:06
|
| One problem still. It doesn''t work for sysobjects which is what I really want it for.All help appreciated. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-13 : 17:17:13
|
| sp_help 'sysobjects'Tara |
|
|
|
|
|
|
Retrieving column names