All Downloads are FREE. Search and download functionalities are using the official Maven repository.

sql-tests.testcases.system.selectInformationSchemaColumns.sql Maven / Gradle / Ivy

There is a newer version: 0.289
Show newest version
-- 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