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`
[ 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 UPDATE_RULE DELETE_RULE TABLE_NAME REFERENCED_TABLE_NAME
def isp_stock_management fk_att_req_user def isp_stock_management PRIMARY NONE RESTRICT RESTRICT attendance_requests users
def isp_stock_management fk_audit_company def isp_stock_management PRIMARY NONE RESTRICT RESTRICT audit_logs companies
def isp_stock_management fk_audit_user def isp_stock_management PRIMARY NONE RESTRICT RESTRICT audit_logs users
def isp_stock_management fk_branches_company def isp_stock_management PRIMARY NONE RESTRICT RESTRICT branches companies
def isp_stock_management fk_customers_branch def isp_stock_management PRIMARY NONE RESTRICT RESTRICT customers branches
def isp_stock_management fk_customers_company def isp_stock_management PRIMARY NONE RESTRICT RESTRICT customers companies
def isp_stock_management fk_device_install_branch def isp_stock_management PRIMARY NONE RESTRICT RESTRICT device_installations branches
def isp_stock_management fk_device_install_company def isp_stock_management PRIMARY NONE RESTRICT RESTRICT device_installations companies
def isp_stock_management fk_device_install_customer def isp_stock_management PRIMARY NONE RESTRICT RESTRICT device_installations customers
def isp_stock_management fk_device_install_engineer def isp_stock_management PRIMARY NONE RESTRICT RESTRICT device_installations users
def isp_stock_management fk_device_install_last_tx def isp_stock_management PRIMARY NONE RESTRICT RESTRICT device_installations stock_transactions
def isp_stock_management fk_device_install_pop def isp_stock_management PRIMARY NONE RESTRICT RESTRICT device_installations pop_locations
def isp_stock_management fk_device_install_product def isp_stock_management PRIMARY NONE RESTRICT RESTRICT device_installations products
def isp_stock_management fk_device_install_removal_tx def isp_stock_management PRIMARY NONE RESTRICT RESTRICT device_installations stock_transactions
def isp_stock_management fk_device_install_serialized def isp_stock_management PRIMARY NONE RESTRICT RESTRICT device_installations serialized_items
def isp_stock_management fk_device_install_tx def isp_stock_management PRIMARY NONE RESTRICT RESTRICT device_installations stock_transactions
def isp_stock_management fk_duty_user def isp_stock_management PRIMARY NONE RESTRICT RESTRICT employee_duty_sessions users
def isp_stock_management fk_location_user def isp_stock_management PRIMARY NONE RESTRICT RESTRICT employee_location_points users
def isp_stock_management fk_employee_workplace_place def isp_stock_management PRIMARY NONE RESTRICT RESTRICT employee_workplace_mappings workplaces
def isp_stock_management fk_employee_workplace_user def isp_stock_management PRIMARY NONE RESTRICT CASCADE employee_workplace_mappings users
def isp_stock_management fk_erp_modules_parent def isp_stock_management PRIMARY NONE RESTRICT SET NULL erp_modules erp_modules
def isp_stock_management fk_franchisee_company def isp_stock_management PRIMARY NONE RESTRICT RESTRICT franchisees companies
def isp_stock_management fk_import_branch def isp_stock_management PRIMARY NONE RESTRICT RESTRICT import_logs branches
def isp_stock_management fk_import_company def isp_stock_management PRIMARY NONE RESTRICT RESTRICT import_logs companies
def isp_stock_management fk_import_created_by def isp_stock_management PRIMARY NONE RESTRICT RESTRICT import_logs users
|
|
|
|
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