[Vadik]

для MSSQL:

select * from sysobjects o
where
objectproperty(o.[id], 'IsUserTable')= 1 and
not exists(
select *
from syscolumns c
where
o.[id] = c.[id] and
c.[name] = 'DataAreaId')
order by [name]