Search This Blog

Wednesday, January 12, 2011

What is heap table in SQL SERVER

A
This script will find heap
table that doesnot contains cluster and non cluster index is heap table because there is no indexing there on to the table. tables selecta.name, b.object_id, b.object_id ,b.type_desc from sys.tables a inner join sys.indexes b on a.object_id = b.object_id and b.type_desc='HEAP'--

No comments:

Post a Comment