A HEAP table in a sql server is a table without a clustered index. It can have non clustered index on it. A Table with a clustered index is called clustered table. Since it does not have clustered index the data in this table won’t be in sorted order. When you want to insert data
When you are troubleshooting or working on any enhancement activities you may want to see the details of the table like how many column table has , the data type of those column or where the table is being used in view ,triggers.. You can simply select the table and press ALT+F1 to view all