T SQL script- to get tables with no clustered indexes

SELECT *  FROM sys.tables
WHERE OBJECTPROPERTY(object_id,'TableHasClustIndex') = 0

See Also:

• T-SQL Scripts