How to find list of tables that does not contain a specific column in SQL Server

// List of table names which doesn't have 'create_time' column.
select name from sys.tables
except
select distinct object_name(object_id) from sys.columns where name = 'create_time'

Last updated