Re: query for tables without PK

From: Narayana Vyas Kondreddi (
Date: 05/20/04

Date: Thu, 20 May 2004 17:37:22 +0100

Use the OBJECTPROPERTY function (the TableHasPrimaryKey option). See SQL
Server Books Online for more information.

Vyas, MVP (SQL Server)
Is .NET important for a database professional?
"Kevin" <> wrote in message
I have a database that I want to use transactional replication on but
several of the tables don't have primary keys - is there a quick query that
I can run that will return a list of the tables without PK's?
Thanks in advance for the help!