This query returns nullability information of the columns.

Query

select table_schema,
       table_name,
       ordinal_position as col_no,
       column_name,
       case when is_nullable
            then 'YES'
            else 'NO'
            end as nullable
from v_catalog.columns
order by table_schema,
         table_name,
         ordinal_position;

Columns

• table_schema - name of schema
• table_name - name of table
• column_name - name of column
• nullable - nullability attribute for the column:
  • YES - is nullable
  • NO - is not nullable

Rows

• One row nullability of the specified column
• Scope of rows - all columns in the database
• Order by - table schema, table_name, column position within table

Sample results