Describe Table Using Sybase

[wandan]

Hi There -

We are trying to get a list of the columns in a table with their respective PK using Sybase SQL? Does anyone know the appropriate code for this?

Thanks.

 

[johnvai]

you can know the table comlumns from the system tables that are hidden in the database.
To see all the table names check the SYSTABLE and to see the columns in any table check the SYSCOLUMN table.

 

[bansalhimanshu]

Or use sp_help

In most cases this serves the purpose.