The ‘SQLTables’ Regular Statement

This article will cover the syntax of the ‘SQLTables’ regular script statement. 

This statement is used to get fields with information about database tables.

Statement syntax

Copy code 


SQLTables;
SQLTablesThis is the whole command, there isn’t any additional input required. The command must be placed after a valid database connection has been made.

Example

The statement is used to return information about a postgreSQL database. The results are filtered down to specific information about all tables.

Copy code 


LIB CONNECT TO 'Public:PostgreSQL_public';
DATA:
Load *;
SQLTables;
TABLES:
Load
	TABLE_NAME
RESIDENT DATA;
DROP TABLE DATA;

Result

The data is loaded into a table ‘TABLES’.