At the time of table or table index fragmented heavily that time we will scan and find out status of table or table index by DBCC SHOWCONTIG command. Table fragmentation (Fragmentation means joining together) occurs when a large number of insert and update operations are performed on table.
Syntax:
DBCC SHOWCONTIG
[
(table_name[,index_name])
]