Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

counting total number of fields 1

Status
Not open for further replies.

jvande

MIS
Joined
Jun 6, 2001
Messages
115
Location
US
I have a huge table and I want to determine how many fields I have.
How do I find out how many fields are in the table.
 
Assuming either sql 7 or 2000

select count(*) from information_schema.columns
where table_name = 'mytable'
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top