Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    32

    Unanswered: Query for Table structure

    Hi,
    I'm looking for some code that will pull back a list all tables in a database that meet a certain requirement - in this case all tables that have an identity column.

    Can anyone point me in the right direction?

    Cheers
    Greg

  2. #2
    Join Date
    Dec 2002
    Location
    Sunny Florida
    Posts
    121
    select object_name(id),* from syscolumns
    where autoval is not null

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •