github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/metadata/information_schema.sql (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;