Table Details in SQL Anywhere?

Question

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)?

Pleiades

I got answer to part of my question regarding table details here: #101004 But still I don't know how to find the list of tables. I have got an idea though, let me try :) – Pleiades

Answer 1

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

Anibalanica

Answer 2

select * from systable  // lists all tables
select * from syscolumn // lists all tables columns

Frenzy

Answer 3

For a particular table:

describe TableName

will return the table's columns, with an indication of the column's type, whether it's nullable and a primary key

Garibald

Answer 4

Assuming Windows: start - All Programs - SQL Anywhere 11 - Sybase Central

Then Connections - Connect with SQL Anywhere 11...

Select "ODBC Data Source name" and pick "SQL Anywhere 11 Demo"

Press OK to see a tree view of the various objects in the database (tables etcetera).

Gorilla

Answer 5

SELECT b.name + '.' + a.name
  FROM sysobjects a, sysusers b
 WHERE a.type IN ('U', 'S')
   AND a.uid = b.uid
 ORDER BY b.name, a.name

This will yield a list of tables and users that have access to them.

Brittain

Answer 6

Use this view: http://dcx.sybase.com/1001/en/dbrfen10/rf-syvcol.html

Try

select * from sys.syscolumns

or just tables which you created:

select * from sys.syscolumns where creator=(select current user)

Moynahan

Answer 7

System proc, sa_describe_query is quite useful

SELECT * FROM sa_describe_query('select * from TableName')

Semester

Answer 8

To get the list of all tables used in the database :

select * from systable //without 's'

To get the list of all columns :

select * from syscolumn //without 's'

Ratepayer

Answer 9

select t.table_name, c.column_name, c.base_type_str, c.nulls from systabcol c key join systab t on t.table_id = c.table_id

http://dcx.sap.com/1200/en/dbreference_en12/syscolumn345.html

Linearity

Answer 10

To select one table details

select * from Table_Name;

To select two different table and Map with id

select * from Table_1 t1,Table2 t2 where t2.id=ti.id;

Rhododendron

Answer 11

select * from user_tables;

desc tablename;

Phiz

That is not valid for SQL Anywhere. – Vigorous