Re: query for tables without PK
From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
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" <firstname.lastname@example.org> 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