Automation Engine Script Guide > AE JCL for SQL > SQL_GET_TABLES

SQL_GET_TABLES

Lists all databaseA database is an organized collection of data including relevant data structures. tables.

Syntax

SQL_GET_TABLES

Comments

The agent writes the result to a report. Exactly one line is output per table. If a schema is available, it is written in front of the table name. Schema and table are separated by a dot.

Examples

All tables of the NORTHWIND database are retrieved.

SQL_GET_TABLES;

Result shown in the report:

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