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

Tables without a clustered index

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 cluster index (heaps)

Code

Line Numbers: On  Off      Plain Text
SELECT s.name AS SchemaName,
		o.name  AS ObjectName
FROM sys.indexes si
JOIN sys.objects o ON si.object_id = o.object_id
JOIN sys.schemas s ON o.schema_id = s.schema_id
WHERE si.type=0 --HEAP
AND o.type ='U' -- USER_TABLE

 


Got a useful script? Click here to upload!


 

  Post Comment
Order By:  
User Comments
      
daisyjane2018
Posted On: 11/9/2018 1:28:14 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

daisyjane2018
Posted On: 1/17/2019 2:26:15 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:18:36 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:51:27 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

Justin1247
United States
Posted On: 7/10/2019 7:21:56 AM

You can get the best pizza restaurant equipment auctions we have the best experts to provide you with the best online used equipment auctions in the US. If you need the best help with our experts you can take the service of the catering and the best online auctions hub help all over the USA.

Scott Martinez
United States
Posted On: 7/10/2019 10:59:02 AM

You can get the best service with us for the stylish cabinet service we have the best experts to provide you with the best kitchen discount Furniture stores in Ohio. You can get the best service with us for the best Dining room and the best Living room furniture in Ohio.

Claud Main
United States
Posted On: 7/10/2019 11:48:55 AM

You can get the best service with us for the Basement Waterproofing System we have the best experts to provide you with the best service in Ohio for the basement work you can get the best service with us for the basement work in Ohio. With us, you can get more basement services with us

Victor Wolford
United States
Posted On: 7/10/2019 1:44:44 PM

You can get the best cheap Web Designing company in the USA we have the best experts to provide you with the best service in the US. You can get the best service of designing in the different designs with us you can get with us. You can visit us for the best business logo design and the best web design services in the US.

Beauvais
Posted On: 10/30/2019 8:29:59 AM [Edited 10/30/2019 8:31:27 AM]

Owner of My Place Realty Kris Thorkelson ?says the key to retaining a good team begins with servant leadership. “You have to take care of your team before you take care of yourself.

Shaikh sahab
Posted On: 11/21/2019 10:45:14 AM

you helped me by this code i was searching about it so far So thanks and keep it up.! Regards, Lead management system in uae