SQL_GET_TABLES

Use SQL_GET_TABLES to list all database tables. The agent writes one line per table to the report. If a schema is available, it is prefixed to the table name and separated by a dot.

Syntax

SQL_GET_TABLES

Examples

All tables of the NORTHWIND database are retrieved.

SQL_GET_TABLES;

The report shows:

dbo.Categories
dbo.CustomerCustomerDemo
dbo.CustomerDemographics
dbo.Customers
dbo.Employees
dbo.EmployeeTerritories
dbo.Order Details
dbo.Orders
dbo.Products
dbo.Region
dbo.Suppliers
dbo.Territories