Below query can be used to find heap table in sql server. SELECT T.Name 'HeaptableName' FROM sys.indexes I INNER JOIN…
When you are troubleshooting or working on any enhancement activities you may want to see the details of the table…