From a Sybase Database, how I can get table description ( field names and types)?

user_103780 0
Viewed 229409

I have access to command line isql and I like to get Meta-Data of all the tables of a given database, possibly in a formatted file. How I can achieve that?

Thanks.

isql sap-ase sybase metadata sql
12 Answers

sp_tables will also work in isql. It gives you the list of tables in the current database.

user_1859880

In the Sybase version I use, the following gives list of columns for selected table

select *
FROM sys.syscolumns sc
where tname = 'YOUR_TABLE_NAME'
--and creator='YOUR_USER_NAME' --if you want to further restrict tables
--according to the user name that created it
user_30140620

For Sybase ASE, sp_columns table_name will return all the table metadata you are looking for.

user_92045630
Related