DEV Community

Query Filter
Query Filter

Posted on

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 = o.id and c.name = 'INTERNTIMESTAMP')
Enter fullscreen mode Exit fullscreen mode

Top comments (0)