Results 1 to 3 of 3

Thread: field defference between two tables

  1. 08-22-2003, 09:26 AM #1
    ravi
    ravi is offline Registered User
    Join Date
    Nov 2002
    Posts
    231

    field defference between two tables

    Do you have any sql statement for find the field difference between two tables?.
    Reply With Quote Reply With Quote
  2. 08-22-2003, 10:02 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Means compare two tables? Try 'sp_columns table_name' or query information_schema.columns.
    Reply With Quote Reply With Quote
  3. 08-25-2003, 09:34 AM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    If you want to find difference in column definiton you have to use syscolumns table to compare column type, precision and scale.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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