Recent
Favorites

Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: information_schema »View: INNODB_SYS_FOREIGN_COLS
Page-related settingsClick 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

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Showing rows 0 - ... This view has at least this number of rows. Please refer to documentation. (Query took 0.0505 seconds.)
SELECT * FROM `INNODB_SYS_FOREIGN_COLS`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
Number of rows:
Filter rows:
IDFOR_COL_NAMEREF_COL_NAMEPOS
journal/eigen_ibfk_1 JID JID 0
journal/journal_ibfk_1 ID JID 0
profile/wp_studypress_activity_ibfk_1 course_id course_id 0
profile/wp_studypress_course_category_ibfk_1 term_id term_id 0
profile/wp_studypress_course_category_ibfk_2 course_id course_id 0
profile/wp_studypress_course_users_ibfk_1 user_id ID 0
profile/wp_studypress_course_users_ibfk_2 course_id course_id 0
profile/wp_studypress_gcourse_ibfk_1 course_id course_id 0
profile/wp_studypress_propositions_ibfk_1 question_id id 0
profile/wp_studypress_questions_ibfk_1 quiz_id id 0
profile/wp_studypress_quiz_result_ibfk_1 quiz_id id 0
profile/wp_studypress_rate_domain_ibfk_1 activity_id id 0
profile/wp_studypress_rate_domain_ibfk_2 user_id ID 0
profile/wp_studypress_rate_domain_ibfk_3 domain_id id 0
profile/wp_studypress_rate_quality_ibfk_1 activity_id id 0
profile/wp_studypress_rate_quality_ibfk_2 user_id ID 0
profile/wp_studypress_slide_ibfk_1 lesson_id id 0
profile/wp_studypress_visite_ibfk_1 activity_id id 0
profile/wp_studypress_visite_ibfk_2 user_id ID 0
pu_website/fk_pu_wc_download_log_permission_id permission_id permission_id 0
pu_website/pu_cartflows_ca_email_history_ibfk_1 template_id id 0
pu_website/pu_cartflows_ca_email_history_ibfk_2 ca_session_id session_id 0
pu_website/pu_cartflows_ca_email_templates_meta_ib... email_template_id id 0
world/city_ibfk_1 CountryCode Code 0
world/countryLanguage_ibfk_1 CountryCode Code 0

|
|
|
Number of rows:
Filter rows:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport Export Display chart Display chart Create view Create view

Bookmark this SQL query Bookmark this SQL query
mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.