Lists all databaseA database is an organized collection of data including relevant data structures. tables.
SQL_GET_TABLES
The agentA program that enables the de-centralized execution of processes (such as deployments) on target systems (computers or business solutions) or a service that provides connectivity to a target system (such as for databases or middleware). An agent is also an object type in the Automation Engine. [Formerly called "Executor."] See also: host writes the result to a reportA report provides more detailed information about a task's execution or a component.. 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.
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
See also:
Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support |
Copyright © 2016 Automic Software GmbH |