June 4th, 2008

The Archives

• SQL, Microsoft

  Microsoft SQL 2005 find tables missing primary keys

  06.04.08 | Permalink | Comment?

  I recently setup replication for Microsoft SQL 2005 server for a client and needed to provide a list of tables to the client without primary keys, as these are not transferred in the replication. This script came in very handy so thought I would share.

  SELECT c.name, b.name
  FROM sys.tables b
  INNER JOIN sys.schemas c ON b.schema_id = […]

Fusion Team Blog