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 :
Customise 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 `UNIQUE_CONSTRAINT_CATALOG` DESC
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
|
|
|
|
Filter rows:
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG Descending Ascending 1 UNIQUE_CONSTRAINT_SCHEMA UNIQUE_CONSTRAINT_NAME MATCH_OPTION UPDATE_RULE DELETE_RULE TABLE_NAME REFERENCED_TABLE_NAME
def biotimedb payroll_leaveformula_pay_code_id_63c7b4bd_fk_att_p... def biotimedb PRIMARY NONE RESTRICT RESTRICT payroll_leaveformula att_paycode
def techgo orders_technician_id_foreign def techgo PRIMARY NONE RESTRICT SET NULL orders technicians
def photostore products_category_id_foreign def photostore PRIMARY NONE RESTRICT SET NULL products categories
def icehrm_db Fk_EmployeeExpenses_category def icehrm_db PRIMARY NONE CASCADE CASCADE employeeexpenses expensescategories
def jobapplications applicants_ibfk_3 def jobapplications PRIMARY NONE RESTRICT RESTRICT applicants grades
def bagisto 1addresses_cart_id_foreign def bagisto PRIMARY NONE RESTRICT CASCADE 1addresses 1cart
def delivery_db delivery_tracking_tbl_ibfk_6 def delivery_db PRIMARY NONE RESTRICT CASCADE delivery_tracking_tbl bills_tbl
def icehrm_db Fk_CompanyAssets_AssetTypes def icehrm_db PRIMARY NONE CASCADE SET NULL companyassets assettypes
def workflow kpi_snapshots_ibfk_1 def workflow PRIMARY NONE RESTRICT SET NULL kpi_snapshots departments
def sales_management sales_details_pro_id_foreign def sales_management PRIMARY NONE CASCADE SET NULL sales_details products
def enjazi_db users_ibfk_1 def enjazi_db PRIMARY NONE RESTRICT SET NULL users departments
def sales_management products_qty_store_id_foreign def sales_management PRIMARY NONE CASCADE CASCADE products_qty store
def bagisto 1orders_customer_id_foreign def bagisto PRIMARY NONE RESTRICT SET NULL 1orders 1customers
def ticket_app_db_test ticket_comments_ibfk_1 def ticket_app_db_test PRIMARY NONE RESTRICT CASCADE ticket_comments tickets
def the_old_database branch_area_ib_fk def the_old_database PRIMARY NONE RESTRICT RESTRICT branch_tbl area_tbl
def sales_inventory_db audit_log_ibfk_1 def sales_inventory_db PRIMARY NONE RESTRICT SET NULL audit_log users
def icehrm_db Fk_EmployeeLeaves_LeavePeriods def icehrm_db PRIMARY NONE RESTRICT RESTRICT employeeleaves leaveperiods
def bagisto 1booking_product_default_slots_booking_product_id_... def bagisto PRIMARY NONE RESTRICT CASCADE 1booking_product_default_slots 1booking_products
def delivery_db_new loads_ibfk_3 def delivery_db_new PRIMARY NONE RESTRICT RESTRICT loads users
def icehrm_db Fk_EmployeeCompanyLoans_Employee def icehrm_db PRIMARY NONE CASCADE CASCADE employeecompanyloans employees
def workflow workflow_actions_ibfk_1 def workflow PRIMARY NONE RESTRICT CASCADE workflow_actions requests
def ecommerce_db category_translations_ibfk_2 def ecommerce_db PRIMARY NONE RESTRICT CASCADE category_translations languages
def enterprise_workflow notifications_ibfk_1 def enterprise_workflow PRIMARY NONE RESTRICT CASCADE notifications users
def biotimedb att_holiday_department_id_fbbbd185_fk_personnel_de... def biotimedb PRIMARY NONE RESTRICT RESTRICT att_holiday personnel_department
def sales_management sanad_sarf_allocations_sanad_sarf_id_foreign def sales_management PRIMARY NONE RESTRICT CASCADE sanad_sarf_allocations sanad_sarf
|
|
|
|
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