SELECT Name ‘Tables without any Indexes’
FROM SYS.tables
WHERE OBJECTPROPERTY(OBJECT_ID,’TableHasIndex’)=0

Advertisements