Get List of tables with no identity columns

SELECT TABLE_NAME
FROM   INFORMATION_SCHEMA.TABLES
WHERE  Table_NAME NOT IN (SELECT c.TABLE_NAME
                          FROM   INFORMATION_SCHEMA.COLUMNS c
                                 INNER JOIN sys.identity_columns ic
                                         ON ( c.COLUMN_NAME = ic.NAME ))
       AND TABLE_TYPE = 'BASE TABLE';