Tables without Primary Key

• J-237021

  SSC Enthusiast

  Points: 126

  More actions

  September 14, 2005 at 11:28 pm

  #110197

  Hi All,

   

  Is there a query to list for me all user tables without primary key.

• Deni Kusdeni

  Default port

  Points: 1457

  More actions

  September 15, 2005 at 12:52 am

  #590019

  Please see this :

  http://www.sqlservercentral.com/scripts/contributions/1092.asp

• Vee

  Hall of Fame

  Points: 3028

  More actions

  September 16, 2005 at 4:37 am

  #590488

  select * from sysobjects where xtype ='u'