-
Columns per Table
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
-
Columns per Table (reply)
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
-
Columns per Table (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|