xls.queries

xls.queries

The xls.queries view is a regular query list view.

It selects the required query list columns:

TABLE_SCHEMATABLE_NAMETABLE_TYPETABLE_CODEINSERT_PROCEDUREUPDATE_PROCEDUREDELETE_PROCEDUREPROCEDURE_TYPE
 

The view selects database objects and the objects defined in the xls.objects table.

Users should choose the xls.queries query list in the connection wizard to connect to the defined objects.

The view does not select the following database objects to suggest a clear object list to connect:

  • System database objects
  • Database objects with the name prefixes like xl_, insert, update, delete, import, export, add, set, etc.
  • Database objects with the name suffixes like insert, update, delete, merge, change, etc.
  • Database objects marked as HIDDEN in the xls.objects table

You can find complete rules in the view definition.

You can use the xls.queries view as a source for your query list views.

See additional notes: