Search code examples
databasesqlanywhere

Table Details in SQL Anywhere?

I just downloaded the developer edition of SQL Anywhere. How can I get a list of tables in the database I'm connected to?. Also for a particular table, how do I get the meta-data for that table (column names, types, etc)?

Solution

  • I have not used SQL-Anywhere for many years however the following statement should work

    select c.column_name
from systabcol c 
   key join systab t on t.table_id=c.table_id 
   where t.table_name='tablename'

    This was cribbed directly from an earlier question