select count(*) as "Number of tables that have INTERNTIMESTAMP column"
from sysobjects o
where o.type = 'U'
and exists (select 1 from syscolumns c where c.id = o.id and c.name = 'INTERNTIMESTAMP')
Intelligence View
diag1
select count(*) as "Number of tables that have INTERNTIMESTAMP column" from sysobjects o where o.type = 'U' and exists (select 1 from syscolumns c where c.id =…