How many columns in a table? 2

[innmedia]

Hi,

Is there any quick way to get a count of fields (columns) in a table?

 

[TJRTech]

select count(*)
from syscolumns c, sysobjects o
where o.name='TABLE_NAME' and c.id=o.id


Just replace TABLE_NAME with whatever.

TR

 

[MDXer]

Another way is

Select
Count(Column_Name)
From INFORMATION_SCHEMA.COLUMNS
Where Table_Name = 'XXX"

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[innmedia]

All -

Thanks!!

 

[TJRTech]

MDXer's approach is better because the INFORMATION_SCHEMA view is supposed to be an abstraction layer and shield from the 'sys' tables so that Microsoft can change them at will. Of course, I think stuff would break all over the place if and when they did, but hey, we have been warned.

TR