Drop files here

SQL upload ( 0 ) x -

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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `REFERENTIAL_CONSTRAINTS` ORDER BY `DELETE_RULE` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG UNIQUE_CONSTRAINT_SCHEMA UNIQUE_CONSTRAINT_NAME MATCH_OPTION UPDATE_RULE DELETE_RULE Descending Ascending 1 TABLE_NAME REFERENCED_TABLE_NAME
def memo_focus memo_email_log_ibfk_1 def memo_focus PRIMARY NONE RESTRICT SET NULL memo_email_log memos
def memo_focus memos_ibfk_1 def memo_focus PRIMARY NONE RESTRICT RESTRICT memos users
def memo_focus memo_cc_ibfk_2 def memo_focus PRIMARY NONE RESTRICT RESTRICT memo_cc users
def memo_focus fk_memos_cancelled_by def memo_focus PRIMARY NONE RESTRICT RESTRICT memos users
def memo_focus users_ibfk_1 def memo_focus PRIMARY NONE RESTRICT RESTRICT users departments
def memo_focus memo_recipients_ibfk_2 def memo_focus PRIMARY NONE RESTRICT RESTRICT memo_recipients users
def memo_focus memo_approvals_ibfk_2 def memo_focus PRIMARY NONE RESTRICT RESTRICT memo_approvals users
def memo_focus memo_approvals_ibfk_1 def memo_focus PRIMARY NONE RESTRICT RESTRICT memo_approvals memos
def vorpcore_92e946 FK_items_item_group def vorpcore_92e946 PRIMARY NONE NO ACTION NO ACTION items item_group
def vorpcore_92e946 fk_ad_caravan_pending_group def vorpcore_92e946 PRIMARY NONE RESTRICT CASCADE ad_caravan_pending_rewards ad_caravan_groups
def vorpcore_92e946 bankusers def vorpcore_92e946 PRIMARY NONE CASCADE CASCADE bank_users users
def vorpcore_92e946 fk_ad_boxitem_items_code def vorpcore_92e946 PRIMARY NONE RESTRICT CASCADE ad_boxitem_items ad_boxitem_codes
def vorpcore_92e946 fk_ad_caravan_members_group def vorpcore_92e946 PRIMARY NONE RESTRICT CASCADE ad_caravan_members ad_caravan_groups
def vorpcore_92e946 fk_registergroups_members_group def vorpcore_92e946 PRIMARY NONE RESTRICT CASCADE ad_registergroups_members ad_registergroups_groups
def memo_focus memo_cc_ibfk_1 def memo_focus PRIMARY NONE RESTRICT CASCADE memo_cc memos
def vorpcore_92e946 fk_ad_caravan_progress_group def vorpcore_92e946 PRIMARY NONE RESTRICT CASCADE ad_caravan_level_progress ad_caravan_groups
def memo_focus memo_attachments_ibfk_1 def memo_focus PRIMARY NONE RESTRICT CASCADE memo_attachments memos
def vorpcore_92e946 fk_registergroups_invites_group def vorpcore_92e946 PRIMARY NONE RESTRICT CASCADE ad_registergroups_invites ad_registergroups_groups
def vorpcore_92e946 fk_ad_caravan_claims_group def vorpcore_92e946 PRIMARY NONE RESTRICT CASCADE ad_caravan_level_claims ad_caravan_groups
def vorpcore_92e946 fk_ad_redeem_code_items_code def vorpcore_92e946 PRIMARY NONE RESTRICT CASCADE ad_redeem_code_items ad_redeem_codes
def memo_focus memo_recipients_ibfk_1 def memo_focus PRIMARY NONE RESTRICT CASCADE memo_recipients memos
def vorpcore_92e946 fk_ad_caravan_invites_group def vorpcore_92e946 PRIMARY NONE RESTRICT CASCADE ad_caravan_invites ad_caravan_groups
def vorpcore_92e946 fk_ad_redeem_code_claims_code def vorpcore_92e946 PRIMARY NONE RESTRICT CASCADE ad_redeem_code_claims ad_redeem_codes
def vorpcore_92e946 FK_characters_users def vorpcore_92e946 PRIMARY NONE CASCADE CASCADE characters users
def vorpcore_92e946 fk_ad_caravan_contrib_group def vorpcore_92e946 PRIMARY NONE RESTRICT CASCADE ad_caravan_contributions ad_caravan_groups
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query