SQL::Connection::ListTables()

Syntax

Table_List as C = <SQL::Connection>.ListTables( [ IncludeTables as L [, IncludeViews as L [, IncludeSystemTables as L [, IncludeSynonyms as L [, IncludeAliases as L ]]]]] )

Argument	Description
Table_List	The retrieved list of tables.
<SQL::Connection>	A SQL::Connection object.
IncludeTables	Optional. Default = .T. (TRUE) = Include tables
IncludeViews	Optional. Default = .F. (FALSE) = Include views
IncludeSystemTables	Optional. Default = .F. (FALSE) = Include system tables
IncludeSynonyms	Optional. Default = .F. (FALSE) = Include synonyms
IncludeAliases	Optional. Default = .F. (FALSE) = Include aliases

Description

The ListTables() method returns a list of tables for the current database.

Supported By

Alpha Five Version 8 Enterprise Edition

Limitations

Desktop applications only.

Examples

dim conn as SQL::Connection

dim connString as C

connString = "{A5API='Access', FileName='c:\program files\a5v8\mdbfiles\alphasports.mdb'}"

if .not. conn.open(connString)

ui_msg_box("Error", conn.CallResult.text)

end

end if

ui_msg_box("Tables", conn.ListTables(.T., .T., .T., .T., .T.))

conn.close()