How to list Tables in SQL Database that not Created Through HEAT

Version 1

    Details

    Is it possible to find and list out the tables in an SQL database that were not created through the HEAT Classic application?


    Resolution

    Run the following in SQL Server Management Studio:

    --Replace DB_Name below with the name of your Database--

    USE DB_Name

    GO

    SELECT NAME

    FROM sys.Tables

    WHERE NAME NOT LIKE 'HEAT%'

    AND NAME NOT IN (SELECT TableName FROM HEATCtrl)