Describe Table Using Sybase
Describe Table Using Sybase
(OP)
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.
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.
RE: Describe Table Using Sybase
To see all the table names check the SYSTABLE and to see the columns in any table check the SYSCOLUMN table.
RE: Describe Table Using Sybase
In most cases this serves the purpose.