Re: query for tables without PK

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
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.

-- 
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Kevin" <anonymous@discussions.microsoft.com> wrote in message
news:398BB944-469B-4C1B-AD9C-0E3500909484@microsoft.com...
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!
Kevin