catalog_foreign_keys

11 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: database_name, table_name, id, seq, table, from, to

Link database_name table_name id seq table from to on_update on_delete match
_internal,catalog_columns,0,0 _internal catalog_columns 0 0 tables database_name database_name NO ACTION NO ACTION NONE
_internal,catalog_columns,0,1 _internal catalog_columns 0 1 tables table_name table_name NO ACTION NO ACTION NONE
_internal,catalog_columns,1,0 _internal catalog_columns 1 0 databases database_name database_name NO ACTION NO ACTION NONE
_internal,catalog_foreign_keys,0,0 _internal catalog_foreign_keys 0 0 tables database_name database_name NO ACTION NO ACTION NONE
_internal,catalog_foreign_keys,0,1 _internal catalog_foreign_keys 0 1 tables table_name table_name NO ACTION NO ACTION NONE
_internal,catalog_foreign_keys,1,0 _internal catalog_foreign_keys 1 0 databases database_name database_name NO ACTION NO ACTION NONE
_internal,catalog_indexes,0,0 _internal catalog_indexes 0 0 tables database_name database_name NO ACTION NO ACTION NONE
_internal,catalog_indexes,0,1 _internal catalog_indexes 0 1 tables table_name table_name NO ACTION NO ACTION NONE
_internal,catalog_indexes,1,0 _internal catalog_indexes 1 0 databases database_name database_name NO ACTION NO ACTION NONE
_internal,catalog_tables,0,0 _internal catalog_tables 0 0 databases database_name database_name NO ACTION NO ACTION NONE
data,custrecordmach_new_abae96cecbd8,0,0 data custrecordmach_new_abae96cecbd8 0 0 customrecordtypes custrecord id NO ACTION NO ACTION NONE

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE catalog_foreign_keys (
    database_name TEXT,
    table_name TEXT,
    id INTEGER,
    seq INTEGER,
    "table" TEXT,
    "from" TEXT,
    "to" TEXT,
    on_update TEXT,
    on_delete TEXT,
    match TEXT,
    PRIMARY KEY (database_name, table_name, id, seq),
    FOREIGN KEY (database_name) REFERENCES databases(database_name),
    FOREIGN KEY (database_name, table_name) REFERENCES tables(database_name, table_name)
);