Supported System Schema Queries

**Table 1** Supported System Schema Queries
DML Syntax	Restriction
System schema queries	The following system schema queries are supported: SELECT version() information_schema.SCHEMA_PRIVILEGES information_schema.TABLE_PRIVILEGES information_schema.USER_PRIVILEGES information_schema.SCHEMATA information_schema.tables information_schema.columns SHOW KEYS FROM `table ` FROM `database NOTE: Supported operators include =, IN, and LIKE. These operators can be associated using AND. Complex queries, such as subquery, JOIN, sorting, aggregate query, and LIMIT, are not supported. information_schema.tables and information_schema.columns support operators < and >.