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 `CONSTRAINT_CATALOG` DESC
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
|
|
|
|
Filter rows:
CONSTRAINT_CATALOG Descending Ascending 1 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 surena_crm fk_attendance_correction_event_request def surena_crm PRIMARY NONE RESTRICT RESTRICT employee_attendance_correction_events employee_attendance_correction_requests
def rajkamal_crm fk_employee_attendance_daily_employee def rajkamal_crm PRIMARY NONE RESTRICT RESTRICT employee_attendance_daily employees
def sgm_crm fk_drca_scheme def sgm_crm PRIMARY NONE RESTRICT RESTRICT discount_rebate_customer_agreements discount_rebate_schemes
def surena_crm fk_attendance_calendar_date_calendar def surena_crm PRIMARY NONE RESTRICT CASCADE attendance_work_calendar_dates attendance_work_calendars
def rajkamal_crm fk_attendance_shift_creator def rajkamal_crm PRIMARY NONE RESTRICT RESTRICT attendance_shift_types user_details
def surena_crm fk_employee_leave_request_branch def surena_crm PRIMARY NONE RESTRICT RESTRICT employee_leave_requests setting_branch_details
def rajkamal_crm fk_employee_leave_day_employee def rajkamal_crm PRIMARY NONE RESTRICT RESTRICT employee_leave_request_days employees
def sgm_crm fk_drie_claim def sgm_crm PRIMARY NONE RESTRICT RESTRICT discount_rebate_itc_evidence discount_rebate_claims
def surena_crm fk_biometric_connectors_created_by def surena_crm PRIMARY NONE RESTRICT RESTRICT biometric_connector_instances user_details
def rajkamal_crm fk_biometric_connectors_created_by def rajkamal_crm PRIMARY NONE RESTRICT RESTRICT biometric_connector_instances user_details
def surena_crm fk_mobile_collection_review_operation def surena_crm PRIMARY NONE RESTRICT RESTRICT mobile_collection_finance_reviews mobile_field_operations
def rajkamal_crm fk_transaction_draft_items_draft def rajkamal_crm PRIMARY NONE RESTRICT CASCADE transaction_draft_items transaction_drafts
def sgm_crm fk_attendance_correction_event_actor def sgm_crm PRIMARY NONE RESTRICT RESTRICT employee_attendance_correction_events user_details
def surena_crm fk_biometric_sync_connector def surena_crm PRIMARY NONE RESTRICT RESTRICT biometric_sync_state biometric_connector_instances
def rajkamal_crm fk_dra_claim def rajkamal_crm PRIMARY NONE RESTRICT RESTRICT discount_rebate_approvals discount_rebate_claims
def sgm_crm fk_attendance_monthly_period_closed_by def sgm_crm PRIMARY NONE RESTRICT RESTRICT attendance_monthly_periods user_details
def sgm_crm fk_employee_leave_event_request def sgm_crm PRIMARY NONE RESTRICT CASCADE employee_leave_events employee_leave_requests
def surena_crm fk_drdr_claim def surena_crm PRIMARY NONE RESTRICT RESTRICT discount_rebate_document_reviews discount_rebate_claims
def rajkamal_crm fk_drgppl_plan def rajkamal_crm PRIMARY NONE RESTRICT RESTRICT discount_rebate_gst_posting_plan_lines discount_rebate_gst_plan_runs
def sgm_crm auth_permission_content_type_id_2f476e4b_fk_django... def sgm_crm PRIMARY NONE RESTRICT RESTRICT auth_permission django_content_type
def sgm_crm fk_mobile_collection_review_operation def sgm_crm PRIMARY NONE RESTRICT RESTRICT mobile_collection_finance_reviews mobile_field_operations
def aiskgl FK_a14_set_ltnwise_asign_header_a06_set_course_sec... def aiskgl PRIMARY NONE RESTRICT RESTRICT a14_set_ltnwise_asign_header a06_set_course_section
def surena_crm fk_drie_tracking def surena_crm PRIMARY NONE RESTRICT RESTRICT discount_rebate_itc_evidence discount_rebate_itc_tracking
def rajkamal_crm fk_drss_scheme def rajkamal_crm PRIMARY NONE RESTRICT RESTRICT discount_rebate_scheme_slabs discount_rebate_schemes
def sgm_crm fk_biometric_event_mapping def sgm_crm PRIMARY NONE RESTRICT RESTRICT biometric_events_raw biometric_employee_mappings
|
|
|
|
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