Skip to main content

SQLServer_Connection.tables

tablesname_likedatabaseschematypesall_fields

Group: Metadata

Documentation​

Returns a materialized Table of all the matching views and tables.

Arguments​

  • name_like: The table name pattern to search for. Supports SQL wildcards (%, _). Defaults to "" which means all tables are selected.
  • database: The database name to search in (default is current).
  • schema: The schema name to search in (defaults to current). If "*" is provided, all schemas are searched.
  • types: The table types to search for. The list of possible values can be obtained using the table_types method. Defaults to a set of most commonly used table types, ignoring internal system tables or indices.
  • all_fields: Return all the fields in the metadata table.

Remarks​

Temporary Tables​

Note that the temporary tables may be created in a different schema than the current one, so take this into account when filtering by schema.