xls.queries
The xls.queries view functions as a standard query list view.
It selects the necessary query list columns:
TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | TABLE_CODE | INSERT_PROCEDURE | UPDATE_PROCEDURE | DELETE_PROCEDURE | PROCEDURE_TYPE |
---|---|---|---|---|---|---|---|
This view selects database objects along with those defined in the xls.objects table.
To connect to the defined objects, users should select the xls.queries query list in the connection wizard.
The view excludes the following database objects to maintain a clear object list for connections:
- System database objects
- Database objects with name prefixes such as xl_, insert, update, delete, import, export, add, set, etc.
- Database objects with name suffixes like insert, update, delete, merge, change, etc.
- Database objects marked as HIDDEN in the xls.objects table
Refer to the view definition for complete rules.
You can also use the xls.queries view as a source for your own query list views.
See additional notes: