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 :
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 `MATCH_OPTION` DESC
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
|
|
|
|
Filter rows:
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG UNIQUE_CONSTRAINT_SCHEMA UNIQUE_CONSTRAINT_NAME MATCH_OPTION Descending Ascending 1 UPDATE_RULE DELETE_RULE TABLE_NAME REFERENCED_TABLE_NAME
def medvantm_pharmacy_db cart_ibfk_1 def medvantm_pharmacy_db PRIMARY NONE RESTRICT CASCADE cart users
def medvantm_pharmacy_db prescription_items_ibfk_1 def medvantm_pharmacy_db PRIMARY NONE RESTRICT CASCADE prescription_items prescriptions
def medvantm_pharmacy_db delivery_ibfk_1 def medvantm_pharmacy_db PRIMARY NONE RESTRICT CASCADE delivery users
def medvantm_pharmacy_db refunds_ibfk_3 def medvantm_pharmacy_db PRIMARY NONE RESTRICT RESTRICT refunds consultations
def medvantm_pharmacy_db orders_ibfk_2 def medvantm_pharmacy_db PRIMARY NONE RESTRICT SET NULL orders delivery
def medvantm_pharmacy_db prescriptions_ibfk_2 def medvantm_pharmacy_db PRIMARY NONE RESTRICT RESTRICT prescriptions users
def medvantm_pharmacy_db refunds_ibfk_2 def medvantm_pharmacy_db PRIMARY NONE RESTRICT RESTRICT refunds orders
def medvantm_pharmacy_db consultations_ibfk_2 def medvantm_pharmacy_db PRIMARY NONE RESTRICT RESTRICT consultations users
def medvantm_pharmacy_db orders_ibfk_1 def medvantm_pharmacy_db PRIMARY NONE RESTRICT RESTRICT orders users
def oapi_db purchase_items_ibfk_1 def oapi_db PRIMARY NONE RESTRICT CASCADE purchase_items purchase_invoices
def medvantm_pharmacy_db prescriptions_ibfk_1 def medvantm_pharmacy_db PRIMARY NONE RESTRICT RESTRICT prescriptions users
def medvantm_pharmacy_db refunds_ibfk_1 def medvantm_pharmacy_db PRIMARY NONE RESTRICT RESTRICT refunds users
def medvantm_pharmacy_db consultations_ibfk_1 def medvantm_pharmacy_db PRIMARY NONE RESTRICT RESTRICT consultations users
def medvantm_pharmacy_db medicine_strengths_ibfk_1 def medvantm_pharmacy_db PRIMARY NONE RESTRICT CASCADE medicine_strengths medicines
def medvantm_pharmacy_db zra_stock_items_ibfk_1 def medvantm_pharmacy_db PRIMARY NONE RESTRICT CASCADE zra_stock_items zra_stock
def medvantm_pharmacy_db order_items_ibfk_3 def medvantm_pharmacy_db PRIMARY NONE RESTRICT RESTRICT order_items medicine_strengths
def medvantm_pharmacy_db prescription_items_ibfk_3 def medvantm_pharmacy_db PRIMARY NONE RESTRICT RESTRICT prescription_items medicine_strengths
def medvantm_pharmacy_db consultant_availability_ibfk_1 def medvantm_pharmacy_db PRIMARY NONE RESTRICT RESTRICT consultant_availability users
def medvantm_pharmacy_db medicines_ibfk_2 def medvantm_pharmacy_db PRIMARY NONE RESTRICT SET NULL medicines categories
def medvantm_pharmacy_db zra_sales_items_ibfk_1 def medvantm_pharmacy_db PRIMARY NONE RESTRICT CASCADE zra_sales_items zra_sales
def medvantm_pharmacy_db order_items_ibfk_2 def medvantm_pharmacy_db PRIMARY NONE RESTRICT RESTRICT order_items medicines
def medvantm_pharmacy_db categories_ibfk_1 def medvantm_pharmacy_db PRIMARY NONE RESTRICT SET NULL categories categories
def medvantm_pharmacy_db prescription_items_ibfk_2 def medvantm_pharmacy_db PRIMARY NONE RESTRICT RESTRICT prescription_items medicines
def medvantm_pharmacy_db medicines_ibfk_1 def medvantm_pharmacy_db PRIMARY NONE RESTRICT SET NULL medicines categories
def medvantm_pharmacy_db zra_purchase_items_ibfk_1 def medvantm_pharmacy_db PRIMARY NONE RESTRICT CASCADE zra_purchase_items zra_purchases
|
|
|
|
Filter rows:
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