Redshift Research Project

System Table Tracker

System view information_schema.data_type_privileges version 1.0.59117 / 2023-11-08

View Text

SELECT CAST(current_database() AS information_schema.sql_identifier) AS object_catalog,
       CAST(x.objschema AS information_schema.sql_identifier) AS object_schema,
       CAST(x.objname AS information_schema.sql_identifier) AS object_name,
       CAST(x.objtype AS information_schema.character_data) AS object_type,
       CAST(x.objdtdid AS information_schema.sql_identifier) AS dtd_identifier
FROM (((SELECT columns.table_schema,
               columns.table_name,
               CAST('TABLE' AS varchar) AS varchar,
               columns.dtd_identifier
        FROM information_schema.columns

        UNION ALL

        SELECT domains.domain_schema,
               domains.domain_name,
               CAST('DOMAIN' AS varchar) AS varchar,
               domains.dtd_identifier
        FROM information_schema.domains)

       UNION ALL

       SELECT parameters.specific_schema,
              parameters.specific_name,
              CAST('ROUTINE' AS varchar) AS varchar,
              parameters.dtd_identifier
       FROM information_schema.parameters)

      UNION ALL

      SELECT routines.specific_schema,
             routines.specific_name,
             CAST('ROUTINE' AS varchar) AS varchar,
             routines.dtd_identifier
      FROM information_schema.routines) AS x (objschema, objname, objtype, objdtdid)

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers