Script to check whether all the tables in a Database have the Primary key or not?

• pshaship

  SSCertifiable

  Points: 6125

  More actions

  September 27, 2010 at 4:39 pm

  #142093

  Basically, I' trying to setup Transaction replication and came to know that every table must have a Primary key to set up Transactional replication.

  So I'm trying to find out the tables having Primary key and the tables that DO NOT have a Primary key.

  Is there any script to do this work?

  Thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736494

  More actions

  September 27, 2010 at 4:55 pm

  #1228089

  This might help: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31603/

• odanwada

  SSCrazy

  Points: 2133

  More actions

  September 27, 2010 at 11:14 pm

  #1228150

  Nice Script it help me a lot.