By David Wiseman (Administrator)Created 25 Mar 2012
My Rating:
Vote
Rating:
Not Rated
Views:4798
Downloads:7
Source:

Tables without a Primary Key Constraint

Language:  T-SQL

Compatibility

SQL Server 7 No SQL Server 2000 No
SQL Server 2005 Yes SQL Server 2008 Yes
Description

List tables without a primary key constraint

Code

Line Numbers: On  Off      Plain Text
SELECT s.name as SchemaName,o.name as ObjectName
FROM sys.objects o
JOIN sys.schemas s on o.[schema_id] = s.[schema_id]
WHERE o.type = 'U'
AND NOT EXISTS(SELECT 1
				FROM sys.indexes si 
				WHERE si.[object_id] = o.[object_id]
				AND is_primary_key = 1)
ORDER BY SchemaName,ObjectName

 


Got a useful script? Click here to upload!


 

  Post Comment
Order By:  
User Comments
      
daisyjane2018
Posted On: 11/9/2018 1:28:16 AM

The league announced the news this morning, writing in a press release that,cheap authentic jerseys "Beginning Friday, November 9, NFL team 'outfits' will be available in the cheap nfl jerseys Shop. This unique opportunity will give Fortnite players the ability to purchase and customize up to eight outfits representing their favorite NFL teams."cheap jerseysWe're just getting started, though! There will also be "football-themed emotes, harvesting tools, gliders, and even a referee outfit." cheap sports jerseys Even a referee outfit! cheap jerseys from chinaSo there you have it, Fortniters (Fortnitees?). Your prayers have been answered. Everyone gets their favorite team's football jersey,wholesale jerseys and themed emotes, and harvesting tools, and gliders. Click here to choose the new cheap authentic jerseys from china and wholesale nfl jerseys! Receive comprehensive coverage of the Bears and stream the ‘Football Aftershow’ easily on your device.click here cheap authentic nfl jerseys.It's not a giant surprise,custom cowboys jersey but it's still impressive to see. Fortnite is hugely popular among professional athletes, and it's football season,discount jerseys after all. Epic Games just announced an official partnership with the NFL to bring licensed jerseys to the popular battle royale game, letting players don the jerseys of their favorite teams as they blast each other into oblivion.discount nfl jerseys cheap nfl jerseys cheap jerseys cheap jerseys from china wholesale jerseys cheap nfl jerseys from china china jerseys nfl jerseys china wholesale nfl jerseys cheap authentic nfl jerseys cheap jerseys online cheap authentic jerseys cheap sports jerseys cheap wholesale jerseys china wholesale jerseys discount nfl jerseys cheap authentic jerseys from china discount jerseys custom cowboys jersey Click here GOOGLE FACKBOOK Amazon nfl jerseys cheap cheap college football jerseys cheap nfl jerseys china cheap football jerseys custom jerseys cheap cheap nfl gear cheap nfl authentic jerseys cheap jerseys nfl nfl football jerseys cheap cheap nfl football jerseys cheap nfl jerseys free shipping cheap nfl nike jerseys custom nfl jerseys cheap nfl cheap jerseys

alicetaylor
Posted On: 1/8/2019 7:06:31 AM

Very interesting! Thanks you total jerkface happy wheels

daisyjane2018
Posted On: 1/17/2019 2:29:04 AM

sac a main michael kors pas cher basket femme pas cher maillot foot pas cher maglie nba a poco prezzo michael kors borse prezzi borse michael kors prezzi maglie calcio a poco prezzo maglie calcio poco prezzo maglie calcio 2019 comprar camisetas de futbol camisetas nba baratas comprar camisetas nba camisetas de nba baratas camisetas de futbol baratas camisetas futbol baratas coach outlet online coach outlet store online coach factory outlet online store coach factory outlet online coach factory outlet online login cheap coach handbags coach factory outlet store coach factory store online cheap nfl jerseys cheap nfl jerseys from china wholesale nfl jerseys cheap polo ralph lauren online kate spade outlet real madrid trikot nba trikots fussball trikots fußball trikot bayern münchen trikot nike trikot schalke trikot 18 19 bayern trikot 2019 fc barcelona trikot neymar trikot atletico madrid trikot football trikot deutschland trikot kinder michael kors outlet michael kors outlet online michael kors factory outlet cheap michael kors bags cheap michael kors purses cheap michael kors chaussures louboutin pas cher christian louboutin louis benech coach outlet store online coach factory outlet online cheap coach purses official coach factory outlet online coach factory outlet online login official coach outlet online cheap coach handbags coach factory store online coach outlet online coach factory outlet coach purses cheap cheap coach handbags coach factory outlet store coach factory store online michael kors outlet online cheap michael kors bags nba sportando nba store eu canotte nba cinema moderno maglie canotte nba a poco prezzo cheap nfl jerseys cheap jerseys from china cheap authentic jerseys cheap nfl authentic jerseys cheap jerseys online cheap polo ralph lauren outlet cheap polo ralph lauren online dortmund trikot manchester united trikot bayern münchen trikot bvb trikot 18 19 maillot de foot pas cher maillot foot pas cher maillot de foot pas cher net cheap football shirts

daisyjane2018
Posted On: 2/21/2019 9:20:12 AM

cheap coach handbags maglie calcio 2019 cheap authentic jerseys coach outlet clearance coach outlet online cheap jerseys online cheap polo ralph lauren online official coach outlet online atletico madrid trikot borse michael kors prezzi camisetas futbol baratas cinema moderno maglie cheap nfl jerseys from china comprar camisetas nba comprar camisetas de futbol tu dortmund unimail sportando nba cheap nfl jerseys maglie calcio poco prezzo cheap nfl authentic jerseys coach factory outlet online login dortmund trikot coach factory outlet online login michael kors borse prezzi coach factory outlet camisetas de nba baratas coach outlet online michael kors borse prezzi coach factory store online neymar trikot coach factory outlet store michael kors outlet online schalke trikot 18 19 deutschland trikot kinder coach factory store online official coach factory outlet online maillot de foot pas cher camisetas de futbol baratas cheap jerseys from china cheap jerseys from china wholesale nfl jerseys maillot de foot pas cher net kate spade outlet cheap coach purses fussball trikots maglie calcio a poco prezzo michael kors outlet coach factory outlet online store nike trikot canotte nba a poco prezzo nba tabellenstand cheap michael kors bags maglie nba a poco prezzo basket femme pas cher real madrid trikot christian louboutin louis benech coach factory outlet store michael kors borse prezzi cheap nfl jerseys chaussures louboutin pas cher maillot foot pas cher cheap nfl jerseys cheap football shirts cheap coach handbags coach outlet store online camisetas nba baratas

daisyjane2018
Posted On: 6/19/2019 8:52:26 AM

??? ?????? ????? ??? ??? ?????? ????? ??? ??? ?????? ?? ??? ??? ?????? ??? ?????? ????? ??? ??? ?? ?????? ??? ?????? ?? ??? ?????? ?????? ??? ??? coach outlet coach outlet clearance coach outlet clearance sale real psg streaming mel ouvert caen borse michael kors michael kors borse outlet sfondi juventus calciomercatonapoli24 pecnapoli mosca rossa torino coach outlet clearance coach purses on clearance stan stephens coupon code cheap nfl jerseys cheap jerseys from china wholesale nfl jerseys prefisso 045 itmagliecalcio shop dobre com cheap phone cases rosewholesale wigs afiba wigs bounty camisetas bounty camisetas vipleague nbaplus horarios nba eu nba sportando michael kors rea michael kors plånbok coach crossbody coach factory outlet online michael kors borse prezzi pochette michael kors borse michael kors outlet cheap authentic jerseys cfb3 camisetas bounty camisetas michael kors plånbok cheap custom phone cases michael kors plånbok official coach outlet online cheap wigs borse michael kors camisetas de futbol baratas camisetas futbol baratas cheap nfl jerseys cheap t shirts cheap t shirt design cheap custom shirts wholesale phone cases cheap jerseys from china cheap lace front wigs cheap nhl jerseys custom t shirts cheap coach factory outlet online cheap phone cases cheap dress shirts cheap lace front wigs cheap authentic jerseys cheap custom shirts www coachoutlet com official coach outlet online mascamisetasnba coach factory outlet online maillot om pas cher survetement foot pas cher maillot equipe de france pas cher coach outlet online coach factory outlet online michael kors väska michael kors plånbok michael kors väska rea michael kors plånbok michael kors väska rea michael kors outlet bolsos michael kors outlet michael kors españa michael kors el corte ingles bolsos michael kors el corte ingles nba sportando nba store eu canotte nba sportando nba maglie nba cheap nfl jerseys cheap jerseys online backpage north jersey backpage jersey shore discount nfl jerseys cheap nhl jerseys cheap nba jerseys cheap ralph lauren polo shirts polo ralph lauren outlet online ralph lauren outlet online rosewholesale wigs afiba wigs rosewholesale wig reviews khabib wig cheap wigs maillotfoot co max maillot maillot thailande maillot equipe de france pas cher maillot psg pas cher cfb3 camisetas camisetas de futbol replicas camisetas de futbol replicas camisetas de futbol baratas notiziario del calcio foggia calcio mania risultati calcio ieri notiziario del calcio serie d foggiacalciomania cfb3