Find tables without a clustered index - SQL Snipplr Social Repository

Revision: 25496

at April 1, 2010 01:36 by tvanzele

Initial Code

SELECT name
FROM sys.objects
WHERE type = â€˜Uâ€™
AND object_id NOT IN
(SELECT object_id FROM sys.indexes WHERE index_id = 1)

Initial URL

Initial Description

Initial Title

Find tables without a clustered index

Initial Tags

sql

Initial Language

SQL