Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: information_schema »View: PARTITIONS
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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 2.3820 seconds.)
SELECT * FROM `PARTITIONS`

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME PARTITION_NAME SUBPARTITION_NAME PARTITION_ORDINAL_POSITION SUBPARTITION_ORDINAL_POSITION PARTITION_METHOD SUBPARTITION_METHOD PARTITION_EXPRESSION SUBPARTITION_EXPRESSION PARTITION_DESCRIPTION TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE CREATE_TIME UPDATE_TIME CHECK_TIME CHECKSUM PARTITION_COMMENT NODEGROUP TABLESPACE_NAME
def herp acc_fin_yr_closing NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 0 15199648742375423 1024 0 2020-06-15 07:54:48 2020-06-15 07:54:48 2020-06-16 06:50:36 NULLNULL
def herp account_book NULLNULLNULLNULLNULLNULLNULLNULLNULL11437 322 3686400 NULL0 0 2024-08-28 12:35:07 NULLNULLNULLNULL
def herp account_book_details NULLNULLNULLNULLNULLNULLNULLNULLNULL39010 94 3686400 NULL0 0 2024-08-28 12:35:07 NULLNULLNULLNULL
def herp account_budget_entry NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 0 281474976710655 1024 0 2020-06-15 07:54:49 2020-06-15 07:54:49 2020-06-16 06:50:37 NULLNULL
def herp account_budget_entry_dtls NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 0 281474976710655 1024 0 2020-06-15 07:54:49 2020-06-15 07:54:49 2020-06-16 06:50:37 NULLNULL
def herp account_cost_category NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 0 281474976710655 1024 0 2020-06-15 07:54:49 2020-06-15 07:54:49 2020-06-16 06:50:37 NULLNULL
def herp account_fund_receipt NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 0 281474976710655 1024 0 2020-06-15 07:54:49 2020-06-15 07:54:49 2020-06-16 06:50:37 NULLNULL
def herp account_fund_receipt_dtls NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 0 281474976710655 1024 0 2020-06-15 07:54:49 2020-06-15 07:54:49 2020-06-16 06:50:37 NULLNULL
def herp account_gstr_3b NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 0 281474976710655 1024 0 2020-06-15 07:54:49 2020-06-15 07:54:49 2020-06-16 06:50:37 NULLNULL
def herp account_gstr_3b_inward_supplies NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 0 16044073672507391 1024 0 2020-06-15 07:54:49 2020-06-15 07:54:49 2020-06-16 06:50:37 NULLNULL
def herp account_gstr_3b_itc NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 0 105271641289785343 1024 0 2020-06-15 07:54:49 2020-06-15 07:54:49 2020-06-16 06:50:37 NULLNULL
def herp account_gstr_3b_outward_supplies NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 0 59672695062659071 1024 0 2020-06-15 07:54:49 2020-06-15 07:54:49 2020-06-16 06:50:37 NULLNULL
def herp account_gstr_3b_payment_tax NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 0 84723967989907455 1024 0 2020-06-15 07:54:49 2020-06-15 07:54:49 2020-06-16 06:50:37 NULLNULL
def herp account_gstr_3b_tds NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 0 16044073672507391 1024 0 2020-06-15 07:54:49 2020-06-15 07:54:49 2020-06-16 06:50:37 NULLNULL
def herp account_gstr_3b_unregistered NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 0 23080948090273791 1024 0 2020-06-15 07:54:49 2020-06-15 07:54:49 2020-06-16 06:50:37 NULLNULL
def herp account_invoice_billbook NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 16384 NULL0 0 2024-08-28 12:35:07 NULLNULLNULLNULL
def herp account_multi_currency NULLNULLNULLNULLNULLNULLNULLNULLNULL1 16384 16384 NULL0 0 2024-08-28 12:35:07 NULLNULLNULLNULL
def herp account_purchase_billbook NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 16384 NULL0 0 2024-08-28 12:35:07 NULLNULLNULLNULL
def herp account_sale_billbook NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 16384 NULL0 0 2024-08-28 12:35:07 NULLNULLNULLNULL
def herp account_service_billbook NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 16384 NULL0 0 2024-08-28 12:35:07 NULLNULLNULLNULL
def herp accountcategory_master NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 16384 NULL0 0 2024-08-28 12:35:07 NULLNULLNULLNULL
def herp accountgroupmaster NULLNULLNULLNULLNULLNULLNULLNULLNULL150 109 16384 NULL0 0 2024-08-28 12:35:07 NULLNULLNULLNULL
def herp accountgroups NULLNULLNULLNULLNULLNULLNULLNULLNULL0 0 16384 NULL16384 0 2024-08-28 12:35:07 NULLNULLNULLNULL
def herp accountledger NULLNULLNULLNULLNULLNULLNULLNULLNULL1251 117 147456 NULL0 0 2024-08-28 12:35:07 NULLNULLNULLNULL
def herp accountledger_dtls NULLNULLNULLNULLNULLNULLNULLNULLNULL1287 25 33408 281474976710655 19456 0 2020-06-15 07:54:49 2023-03-22 09:22:48 2023-04-21 04:22:55 NULLNULL