找到堆表

select t.name from sys.tables t left join sys.indexes i
on t.object_id=i.object_id
and i.index_id=1
where i.index_id is null
and is_ms_shipped=0

posted on 2011-05-24 11:55  stswordman  阅读(208)  评论(0编辑  收藏  举报