-
field defference between two tables
Do you have any sql statement for find the field difference between two tables?.
-
Means compare two tables? Try 'sp_columns table_name' or query information_schema.columns.
-
If you want to find difference in column definiton you have to use syscolumns table to compare column type, precision and scale.
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
|
|