Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: information_schema »View: KEY_COLUMN_USAGE
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 :

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.1555 seconds.)
SELECT * FROM `KEY_COLUMN_USAGE`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
Number of rows:
Filter rows:
CONSTRAINT_CATALOGCONSTRAINT_SCHEMACONSTRAINT_NAMETABLE_CATALOGTABLE_SCHEMATABLE_NAMECOLUMN_NAMEORDINAL_POSITIONPOSITION_IN_UNIQUE_CONSTRAINTREFERENCED_TABLE_SCHEMAREFERENCED_TABLE_NAMEREFERENCED_COLUMN_NAME
def assets PRIMARY def assets inventory_breakage id 1 NULL NULL NULL NULL
def assets PRIMARY def assets tbl_admin id 1 NULL NULL NULL NULL
def assetslhr PRIMARY def assetslhr inventory_breakage id 1 NULL NULL NULL NULL
def assetslhr PRIMARY def assetslhr tbl_admin id 1 NULL NULL NULL NULL
def bistro PRIMARY def bistro commentcard id 1 NULL NULL NULL NULL
def bistro PRIMARY def bistro page_permissions id 1 NULL NULL NULL NULL
def bistro PRIMARY def bistro ratings id 1 NULL NULL NULL NULL
def bistro PRIMARY def bistro restaurantinfo id 1 NULL NULL NULL NULL
def bistro PRIMARY def bistro tbl_admin id 1 NULL NULL NULL NULL
def bistro PRIMARY def bistro tbl_daily_cash id 1 NULL NULL NULL NULL
def cafe PRIMARY def cafe customer_types type_id 1 NULL NULL NULL NULL
def cafe PRIMARY def cafe designation id 1 NULL NULL NULL NULL
def cafe PRIMARY def cafe purchaser_details id 1 NULL NULL NULL NULL
def cafe PRIMARY def cafe tbl_admin id 1 NULL NULL NULL NULL
def cafe PRIMARY def cafe tbl_attendance id 1 NULL NULL NULL NULL
def cafe PRIMARY def cafe tbl_brands id 1 NULL NULL NULL NULL
def cafe PRIMARY def cafe tbl_calculations id 1 NULL NULL NULL NULL
def cafe PRIMARY def cafe tbl_cashdetails id 1 NULL NULL NULL NULL
def cafe PRIMARY def cafe tbl_cities id 1 NULL NULL NULL NULL
def cafe title def cafe tbl_cities title 1 NULL NULL NULL NULL
def cafe PRIMARY def cafe tbl_customers id 1 NULL NULL NULL NULL
def cafe title def cafe tbl_customers title 1 NULL NULL NULL NULL
def cafe PRIMARY def cafe tbl_cus_payments id 1 NULL NULL NULL NULL
def cafe PRIMARY def cafe tbl_daily_cash id 1 NULL NULL NULL NULL
def cafe PRIMARY def cafe tbl_daily_closing demand_id 1 NULL NULL NULL NULL
|
|
|
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