DEV Community

Query Filter
Query Filter

Posted on

catalog

SELECT o.name AS table_name
FROM sysobjects o
WHERE o.type = 'U'
  AND o.uid = USER_ID()
  AND EXISTS (
        SELECT 1 FROM syscolumns c
        WHERE c.id = o.id AND LOWER(c.name) = 'orderid'
      )
  AND EXISTS (
        SELECT 1 FROM syscolumns c
        WHERE c.id = o.id AND LOWER(c.name) = 'interntimestamp'
      )
ORDER BY o.name;

Enter fullscreen mode Exit fullscreen mode

Top comments (0)