Columns per Table

[Tracy Young]

I need to find out the number of columns per table for ALL of my tables in
my database. This way I can compare my old copy of the database to the new and make sure that any new columns are there.

Thank you,

Tracy Young

[Jarlath O'Grady]

Tracy

A total columns count may fail if columns have been some added and others removed, giving the same columns count.

A record of each column within each table is held for each individual dataabse, in the system table syscolumns. A direct comparison between these tables from each database would prove to be a more effective method.

All the best

Jarlath O'Grady
mailto:jogrady@swynk.com
http://www.swynk.com/friends/ogrady

------------
Tracy Young at 9/13/99 4:15:47 PM

I need to find out the number of columns per table for ALL of my tables in
my database. This way I can compare my old copy of the database to the new and make sure that any new columns are there.

Thank you,

Tracy Young

[Steve Jimmo]

Tracy,

"select * from sysobjects where type='U'"

will give you a list of the names of the tables in a particular database and select count(*) from sysobjects where type='U' will give you just the number of tables

Steve Jimmo

------------
Tracy Young at 9/13/99 4:15:47 PM

I need to find out the number of columns per table for ALL of my tables in
my database. This way I can compare my old copy of the database to the new and make sure that any new columns are there.

Thank you,

Tracy Young