Post reply

Finding Tables without primary keys and clustered indexes.

  • September 4, 2008 at 2:51 am

    #866998

    Primary key:

    SELECT name from sys.tables where objectproperty(object_id,'TableHasPrimaryKey') = 0

    Clustered index:

    SELECT name from sys.tables where objectproperty(object_id,'TableHasClustIndex') = 0

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 4, 2008 at 3:23 am

    #867011

    'to run this query ,to get result of non using primary key or cluster index tables

    SELECT name ,case when objectproperty(object_id,'TableHasPrimaryKey') =0 then 'No' else 'Yes' end IsPrimaryKey,

    case when objectproperty(object_id,'TableHasClustIndex') =0 then 'No' else 'Yes' end IsClustIndex

    from sys.tables where objectproperty(object_id,'TableHasPrimaryKey') =0 or objectproperty(object_id,'TableHasClustIndex') = 0

  • September 4, 2008 at 4:17 am

    #867026

    Hello,

    Thank you both for replying, I got what was needed from them.

    Cheers,

    P.

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply