xls.queries

xls.queries

The xls.queries view functions as a standard query list view.

It selects the necessary query list columns:

TABLE_SCHEMATABLE_NAMETABLE_TYPETABLE_CODEINSERT_PROCEDUREUPDATE_PROCEDUREDELETE_PROCEDUREPROCEDURE_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:

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.