Returns the list of table names, catalog names, or schema names, and the table types that are stored in a specific data source. The information is returned as a result set on the statement handle.
hstmnt = DB_Tables (hdbc, catalog-name, schema-name, table-name, table-type)
| Variable | Description |
|---|---|
| hstmnt |
The returned handle to the executed SQL statement. This is an input parameter for other DBTester functions, for example DB_FetchNext. HSQL. |
| hdbc |
The handle to a database as returned by DB_Connect. HDATABASE. |
| catalog-name |
Catalog name. STRING. |
| schema-name |
String search pattern for schema names. STRING. |
| table-name |
String search pattern for table names. STRING. |
| table-type |
List of table types to match.
|
DB_Tables corresponds to SQLTables. For additional information about SQLTables, see SQLTables Function.
| Wildcard character | Matches |
|---|---|
| % | The percent sign matches any character sequence. |
| _ | The underscore matches any single character. |
To omit an argument variable, specify it as NULL.
When you receive a valid statement handle, you can call DB_FetchNext or DB_FetchPrevious to manipulate the information.
The wildcards do not work in a DB_Tables call against SQL Server. If you use these wildcards in such a call, Silk Test Classic returns no information.
[-] testcase DBTablesExample () appstate none
[ ] // Retrieve all tables beginning with the letter 'p' (or 'P').
[ ] // Assume that hdbc is a valid database handle returned from DB_Connect().
[ ] STRING cat, sch, tbl, name, tbltype, ignore
[ ]
[ ] cat = NULL
[ ] sch = NULL
[ ] tbl = "p%"
[ ] tbltype = NULL
[ ]
[ ] HDATABASE hdbc
[ ] HSQL hstmnt
[ ]
[ ] hdbc =DB_Connect("DSN=<DSNNAME>")
[ ]
[ ] // retrieve and print table name; ignore the rest.
[ ] hstmnt = DB_Tables (hdbc, cat, sch, tbl, tbltype)
[-] while (DB_FetchNext (hstmnt,ignore,ignore,name,ignore) == TRUE)
[ ] print (name)
[ ]
[ ] DB_Disconnect (hdbc)