github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/metadata/information_schema.result (about)

     1  select information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_SCHEMA,
     2  information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME,
     3  information_schema.REFERENTIAL_CONSTRAINTS.TABLE_NAME,
     4  information_schema.REFERENTIAL_CONSTRAINTS.REFERENCED_TABLE_NAME,
     5  information_schema.REFERENTIAL_CONSTRAINTS.UNIQUE_CONSTRAINT_NAME,
     6  information_schema.REFERENTIAL_CONSTRAINTS.UNIQUE_CONSTRAINT_SCHEMA,
     7  information_schema.KEY_COLUMN_USAGE.COLUMN_NAME
     8  from information_schema.REFERENTIAL_CONSTRAINTS
     9  join information_schema.KEY_COLUMN_USAGE
    10  on (information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_SCHEMA =
    11  information_schema.KEY_COLUMN_USAGE.CONSTRAINT_SCHEMA and
    12  information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME =
    13  information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME and
    14  information_schema.REFERENTIAL_CONSTRAINTS.TABLE_NAME =
    15  information_schema.KEY_COLUMN_USAGE.TABLE_NAME)
    16  where (information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_SCHEMA in ('plat_content') or
    17  information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_SCHEMA in ('plat_content'))
    18  order by information_schema.KEY_COLUMN_USAGE.CONSTRAINT_SCHEMA asc,
    19  information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME asc,
    20  information_schema.KEY_COLUMN_USAGE.ORDINAL_POSITION asc;
    21  constraint_schema    constraint_name    table_name    referenced_table_name    unique_constraint_name    unique_constraint_schema    column_name