Metadata queries

To see basic metadata about your indices, use the SHOW and DESCRIBE commands.

Rule showStatement:

Rule showFilter:

To see metadata for indices that match a specific pattern, use the SHOW command. Use the wildcard % to match all indices:

SHOW TABLES LIKE %

TABLE_CAT	TABLE_SCHEM	TABLE_NAME	TABLE_TYPE	REMARKS	TYPE_CAT	TYPE_SCHEM	TYPE_NAME	SELF_REFERENCING_COL_NAME	REF_GENERATION
docker-cluster	null	accounts	BASE TABLE	null	null	null	null	null	null
docker-cluster	null	employees_nested	BASE TABLE	null	null	null	null	null	null

To see metadata for an index name with a prefix of acc:

SHOW TABLES LIKE acc%

TABLE_CAT	TABLE_SCHEM	TABLE_NAME	TABLE_TYPE	REMARKS	TYPE_CAT	TYPE_SCHEM	TYPE_NAME	SELF_REFERENCING_COL_NAME	REF_GENERATION
docker-cluster	null	accounts	BASE TABLE	null	null	null	null	null	null

To see metadata for field names that match a specific pattern, use the DESCRIBE command:

DESCRIBE TABLES LIKE accounts

TABLE_CAT	TABLE_SCHEM	TABLE_NAME	COLUMN_NAME	DATA_TYPE	TYPE_NAME	COLUMN_SIZE	BUFFER_LENGTH	DECIMAL_DIGITS	NUM_PREC_RADIX	NULLABLE	REMARKS	COLUMN_DEF	SQL_DATA_TYPE	SQL_DATETIME_SUB	CHAR_OCTET_LENGTH	ORDINAL_POSITION	SCOPE_CATALOG	SCOPE_SCHEMA	SCOPE_TABLE	SOURCE_DATA_TYPE	IS_AUTOINCREMENT
docker-cluster	null	accounts	account_number	null	long	null	null	null	10	2	null	null	null	null	null	1	null	null	null	null	NO
docker-cluster	null	accounts	firstname	null	text	null	null	null	10	2	null	null	null	null	null	2	null	null	null	null	NO
docker-cluster	null	accounts	address	null	text	null	null	null	10	2	null	null	null	null	null	3	null	null	null	null	NO
docker-cluster	null	accounts	balance	null	long	null	null	null	10	2	null	null	null	null	null	4	null	null	null	null	NO
docker-cluster	null	accounts	gender	null	text	null	null	null	10	2	null	null	null	null	null	5	null	null	null	null	NO
docker-cluster	null	accounts	city	null	text	null	null	null	10	2	null	null	null	null	null	6	null	null	null	null	NO
docker-cluster	null	accounts	employer	null	text	null	null	null	10	2	null	null	null	null	null	7	null	null	null	null	NO
docker-cluster	null	accounts	state	null	text	null	null	null	10	2	null	null	null	null	null	8	null	null	null	null	NO
docker-cluster	null	accounts	age	null	long	null	null	null	10	2	null	null	null	null	null	9	null	null	null	null	NO
docker-cluster	null	accounts	email	null	text	null	null	null	10	2	null	null	null	null	null	10	null	null	null	null	NO
docker-cluster	null	accounts	lastname	null	text	null	null	null	10	2	null	null	null	null	null	11	null	null	null	null	NO

Metadata Queries