SQL Syntax for Sybase Adaptive Server Anywhere V. 6.0.3.2747

Is there any SQL syntax that I can use via Interactive SQL for a Sybase Adaptive Server Anywhere V. 6.0.3.2747 database to query tables and recieve a description of it's columns, primary and foreign keys, and maybe even the size and data types of it's columns?  Something equivalent to the describe statement for Oracle and DB2?
cwilliams122399Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
amitpagarwalConnect With a Mentor Commented:

sp_helpconstraint tablename
will give the list of all keys and references made by the table

sp_columns tablename would list all the information about the columns of the table

sp_help tablename would give all the information present about that table

thanks
0
 
jkotekCommented:
Look for the tables sys.syscolumns and sys.systable and other tables owned by 'SYS' user (they are not displayed in Sybase Central by default - r-click on database, 'filter objects')
0
All Courses

From novice to tech pro — start learning today.