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 payitsea_jnablr FK_a01_set_school_code_a01_set_locations def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a01_set_school_code a01_set_locations
def payitsea_jnablr FK_a03_set_institutiontype_a02_set_academic_year def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a03_set_institutiontype a02_set_academic_year
def payitsea_jnablr FK_a04_set_course_group_a03_set_institutiontype def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a04_set_course_group a03_set_institutiontype
def payitsea_jnablr FK_a05_set_course_r_batch_a04_set_course_group def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a05_set_course_r_batch a04_set_course_group
def payitsea_jnablr FK_a06_set_course_section_a05_set_course_r_batch def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a06_set_course_section a05_set_course_r_batch
def payitsea_jnablr FK_a08_set_header_a07_set_header_group def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a08_set_header a07_set_header_group
def payitsea_jnablr FK_a12_ltnwise_exam_grp_b01_parta_group def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a12_set_ltnwise_asign_exam_grp b01_set_exam_parta_group
def payitsea_jnablr FK_a12_set_ltnwise_asign_exam_grp_a01_set_location... def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a12_set_ltnwise_asign_exam_grp a01_set_locations
def payitsea_jnablr FK_a12_set_ltnwise_asign_exam_grp_a06_set_course_s... def payitsea_jnablr NULL NONE RESTRICT RESTRICT a12_set_ltnwise_asign_exam_grp a06_set_course_section1
def payitsea_jnablr FK_a13_set_ltnwise_asign_course_sec_grp_a01_set_lo... def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a13_set_ltnwise_asign_course_sec_grp a01_set_locations
def payitsea_jnablr FK_a13_set_ltnwise_asign_course_sec_grp_a06_set_co... def payitsea_jnablr NULL NONE RESTRICT RESTRICT a13_set_ltnwise_asign_course_sec_grp a06_set_course_section1
def payitsea_jnablr FK_a14_set_ltnwise_asign_header_a01_set_locations def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a14_set_ltnwise_asign_header a01_set_locations
def payitsea_jnablr FK_a14_set_ltnwise_asign_header_a06_set_course_sec... def payitsea_jnablr NULL NONE RESTRICT RESTRICT a14_set_ltnwise_asign_header a06_set_course_section1
def payitsea_jnablr FK_a14_set_ltnwise_asign_header_a08_set_header def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a14_set_ltnwise_asign_header a08_set_header
def payitsea_jnablr FK_a15_set_ltnwise_asign_exam_grade_grp_a01_set_lo... def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a15_set_ltnwise_asign_exam_grade_grp a01_set_locations
def payitsea_jnablr FK_a15_set_ltnwise_asign_exam_grade_grp_a06_set_co... def payitsea_jnablr NULL NONE RESTRICT RESTRICT a15_set_ltnwise_asign_exam_grade_grp a06_set_course_section1
def payitsea_jnablr FK_a15_ltn_exam_grade_grp_part_b_a01_loca def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a15_set_ltnwise_asign_exam_grade_grp_part_b a01_set_locations
def payitsea_jnablr FK_a15_ltnwise_grade_grp_part_b_a06_section def payitsea_jnablr NULL NONE RESTRICT RESTRICT a15_set_ltnwise_asign_exam_grade_grp_part_b a06_set_course_section1
def payitsea_jnablr FK_a15_ltnwise_grade_grp_part_b_b09_exam_grade_met... def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a15_set_ltnwise_asign_exam_grade_grp_part_b b09_set_exam_grade_method_part_b
def payitsea_jnablr FK_a18_set_ltnwise_asign_school_info_a01_set_locat... def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a18_set_ltnwise_asign_school_info a01_set_locations
def payitsea_jnablr FK_a18_set_ltnwise_asign_school_info_a01_set_schoo... def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a18_set_ltnwise_asign_school_info a01_set_school_info
def payitsea_jnablr FK_a18_set_ltnwise_asign_school_info_a05_set_cours... def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT a18_set_ltnwise_asign_school_info a05_set_course_r_batch
def payitsea_jnablr FK_b01_set_exam_parta_terms_b01_set_exam_parta_gro... def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT b01_set_exam_parta_terms b01_set_exam_parta_group
def payitsea_jnablr FK_b02_set_exam_parta_mainactivity_b01_set_exam_pa... def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT b02_set_exam_parta_mainactivity b01_set_exam_parta_terms
def payitsea_jnablr FK_b03_set_exam_parta_mainsubject_b02_parta_mactiv... def payitsea_jnablr PRIMARY NONE RESTRICT RESTRICT b03_set_exam_parta_mainsubject b02_set_exam_parta_mainactivity
|
|
|
|
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