Listing tables on a SQL Anywhere using iSQL

Question

Is there a way to list all the tables on a SQL Anywhere using iSQL?

score 1 · Answer 1 · answered Jan 10 '12 at 17:46

1

select table_name from sys.systab where table_type_str = 'BASE'

You can change 'BASE' to 'VIEW' to get views, and 'GBL TEMP' to get global temporary tables.

answered Jan 10 '12 at 17:46

Graeme Perrow

score -1 · Answer 2 · answered Jun 23 '11 at 13:02

-1

I am not sure is this will work or not, but try this:

select TABLE_NAME from INFORMATION_SCHEMA.TABLES

I believe this is a database independent way of getting a list of tables.

answered Jun 23 '11 at 13:02

jftuga

2 Answers2