Post reply

query to Find out tables not having primary key in the database

  • September 16, 2010 at 6:24 am

    #227797

    I want to find out how many tables not having primary key in the database using sql query.

    Can any one please help me out ?

  • September 16, 2010 at 6:28 am

    #1222118

    SELECT name AS TableName FROM sys.tables WHERE OBJECTPROPERTY(object_id,'TableHasPrimaryKey') = 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 16, 2010 at 9:24 am

    #1222289

    thank you

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

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