• Home
• io.trino
• trino-product-tests
• 459
• source code
• selectInformationSchemaColumns.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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