SQL-Browser

[Tools]  Database: `information_schema`  Table: `REFERENTIAL_CONSTRAINTS`

   show less  show more             Upload SQL file   Search   MySQl Documentation
The execution of SQL Statements can manipulate data. TAKE CARE! The Authors don't accept any liability for damaged or lost data.

Tables of Database `information_schema` edit
create table:
copy table:
select table:     

 

Table `REFERENTIAL_CONSTRAINTS`
Table properties of `REFERENTIAL_CONSTRAINTS` (11 Fields)Name
Engine
Row Format
Charset
Collation
Comment
 

 

Fields of table `REFERENTIAL_CONSTRAINTS`
insert new field

 FieldTypeSizeNULLKeyAttributeDefaultExtraCollationComment
edit field  delete field  1.CONSTRAINT_CATALOGvarchar512noutf8_general_ci
edit field  delete field  2.CONSTRAINT_SCHEMAvarchar64noutf8_general_ci
edit field  delete field  3.CONSTRAINT_NAMEvarchar64noutf8_general_ci
edit field  delete field  4.UNIQUE_CONSTRAINT_CATALOGvarchar512noutf8_general_ci
edit field  delete field  5.UNIQUE_CONSTRAINT_SCHEMAvarchar64noutf8_general_ci
edit field  delete field  6.UNIQUE_CONSTRAINT_NAMEvarchar64yesutf8_general_ci
edit field  delete field  7.MATCH_OPTIONvarchar64noutf8_general_ci
edit field  delete field  8.UPDATE_RULEvarchar64noutf8_general_ci
edit field  delete field  9.DELETE_RULEvarchar64noutf8_general_ci
edit field  delete field  10.TABLE_NAMEvarchar64noutf8_general_ci
edit field  delete field  11.REFERENCED_TABLE_NAMEvarchar64noutf8_general_ci

Indexes of table `REFERENTIAL_CONSTRAINTS`
  Name Columns Size Type Duplicates allowed Cardinality Comment
No Indexes in Table