sql-tests.testcases.system.selectInformationSchemaColumns.sql Maven / Gradle / Ivy
-- database: presto; groups: system
select
table_catalog,
table_schema,
table_name,
column_name,
data_type,
is_nullable,
column_default,
comment
from SYSTEM.information_schema.columns
where table_schema <> 'jdbc'
order by
table_catalog,
table_schema,
table_name,
ordinal_position
© 2015 - 2024 Weber Informatics LLC | Privacy Policy