Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: information_schema »View: REFERENTIAL_CONSTRAINTS
Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Showing rows 0 - ... This view has at least this number of rows. Please refer to documentation. (Query took 0.1449 seconds.)
SELECT * FROM `REFERENTIAL_CONSTRAINTS`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
Number of rows:
Filter rows:
CONSTRAINT_CATALOGCONSTRAINT_SCHEMACONSTRAINT_NAMEUNIQUE_CONSTRAINT_CATALOGUNIQUE_CONSTRAINT_SCHEMAUNIQUE_CONSTRAINT_NAMEMATCH_OPTIONUPDATE_RULEDELETE_RULETABLE_NAMEREFERENCED_TABLE_NAME
def hortifruti bairro_ibfk_1 def hortifruti PRIMARY NONE RESTRICT RESTRICT bairro cidade
def hortifruti cidade_ibfk_1 def hortifruti PRIMARY NONE RESTRICT RESTRICT cidade uf
def hortifruti cliente_ibfk_1 def hortifruti PRIMARY NONE RESTRICT RESTRICT cliente pessoa
def hortifruti contas_pagar_ibfk_1 def hortifruti PRIMARY NONE RESTRICT RESTRICT contas_pagar nfe
def hortifruti contas_pagar_ibfk_2 def hortifruti PRIMARY NONE RESTRICT RESTRICT contas_pagar pedido_compra
def hortifruti contas_receber_ibfk_1 def hortifruti PRIMARY NONE RESTRICT RESTRICT contas_receber nfe
def hortifruti contas_receber_ibfk_2 def hortifruti PRIMARY NONE RESTRICT RESTRICT contas_receber cupom
def hortifruti cupom_ibfk_1 def hortifruti PRIMARY NONE RESTRICT RESTRICT cupom empresa
def hortifruti cupom_ibfk_2 def hortifruti PRIMARY NONE RESTRICT RESTRICT cupom venda
def hortifruti cupom_ibfk_3 def hortifruti PRIMARY NONE RESTRICT RESTRICT cupom funcionario
def hortifruti cupom_ibfk_4 def hortifruti PRIMARY NONE RESTRICT RESTRICT cupom cliente
def hortifruti cupom_pag_ibfk_1 def hortifruti PRIMARY NONE RESTRICT RESTRICT cupom_pag tipo_pagamento
def hortifruti cupom_pag_ibfk_2 def hortifruti PRIMARY NONE RESTRICT RESTRICT cupom_pag cupom
def hortifruti cupom_produtos_ibfk_1 def hortifruti PRIMARY NONE RESTRICT RESTRICT cupom_produtos produto
def hortifruti cupom_produtos_ibfk_2 def hortifruti PRIMARY NONE RESTRICT RESTRICT cupom_produtos cupom
def hortifruti endereco_ibfk_1 def hortifruti PRIMARY NONE RESTRICT RESTRICT endereco rua
def hortifruti fornecedor_ibfk_1 def hortifruti PRIMARY NONE RESTRICT RESTRICT fornecedor pessoa
def hortifruti funcionario_ibfk_1 def hortifruti PRIMARY NONE RESTRICT RESTRICT funcionario pessoa
def hortifruti movimento_ibfk_1 def hortifruti PRIMARY NONE RESTRICT RESTRICT movimento conta
def hortifruti nfe_ibfk_1 def hortifruti PRIMARY NONE RESTRICT RESTRICT nfe empresa
def hortifruti nfe_entrada_ibfk_1 def hortifruti PRIMARY NONE RESTRICT RESTRICT nfe_entrada fornecedor
def hortifruti nfe_entrada_ibfk_2 def hortifruti PRIMARY NONE RESTRICT RESTRICT nfe_entrada nfe
def hortifruti nfe_pag_ibfk_1 def hortifruti PRIMARY NONE RESTRICT RESTRICT nfe_pag tipo_pagamento
def hortifruti nfe_pag_ibfk_2 def hortifruti PRIMARY NONE RESTRICT RESTRICT nfe_pag nfe
def hortifruti nfe_produtos_ibfk_1 def hortifruti PRIMARY NONE RESTRICT RESTRICT nfe_produtos produto
|
|
|
Number of rows:
Filter rows:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport ExportDisplay chart Display chartCreate view Create view