Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: information_schema »View: INNODB_SYS_TABLES
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.0066 seconds.)
SELECT * FROM `INNODB_SYS_TABLES`
TABLE_IDNAMEFLAGN_COLSSPACEROW_FORMATZIP_PAGE_SIZESPACE_TYPE
14 SYS_DATAFILES 0 5 0 Redundant 0 System
11 SYS_FOREIGN 0 7 0 Redundant 0 System
12 SYS_FOREIGN_COLS 0 7 0 Redundant 0 System
13 SYS_TABLESPACES 0 6 0 Redundant 0 System
15 SYS_VIRTUAL 0 6 0 Redundant 0 System
3014 arena/customer_types 33 5 2999 Dynamic 0 Single
3017 arena/purchaser_details 33 8 3002 Dynamic 0 Single
3020 arena/tbl_attendance 33 9 3005 Dynamic 0 Single
3023 arena/tbl_calculations 33 31 3008 Dynamic 0 Single
3026 arena/tbl_cashdetails 33 9 3011 Dynamic 0 Single
3029 arena/tbl_cities 33 6 3014 Dynamic 0 Single
3035 arena/tbl_cus_payments 33 13 3020 Dynamic 0 Single
3032 arena/tbl_customers 33 14 3017 Dynamic 0 Single
3038 arena/tbl_daily_cash 33 14 3023 Dynamic 0 Single
3041 arena/tbl_daily_closing 33 17 3026 Dynamic 0 Single
3044 arena/tbl_demand_record 33 19 3029 Dynamic 0 Single
3050 arena/tbl_emp_payments 33 13 3035 Dynamic 0 Single
3047 arena/tbl_employees 33 26 3032 Dynamic 0 Single
3056 arena/tbl_exp_categories 33 9 3041 Dynamic 0 Single
3053 arena/tbl_expenses 33 22 3038 Dynamic 0 Single
3059 arena/tbl_items 33 18 3044 Dynamic 0 Single
3062 arena/tbl_leaves_use 33 8 3047 Dynamic 0 Single
3065 arena/tbl_points 33 10 3050 Dynamic 0 Single
3068 arena/tbl_products 33 14 3053 Dynamic 0 Single
3074 arena/tbl_pur_items 33 23 3059 Dynamic 0 Single