Very Computer

> Hello all,

> We are currently using "sp_columns <table_name>" to find out the column
> names and data types for any given table.  Unfortunately, the sp_columns
> procedure is too slow for our purposes and is severely hindering our
> application (which is a perl script running on Apache mod_perl with
> DBI/DBD::Sybase).  Is there a faster way to just find out the column
> names and data types for a table?  Perhaps there are some internal
> tables we can query?  Or perhaps to write a striped down, more efficient
> version of sp_columns which only provides the bare bones information we
> need?

> Any help for this Sybase rookie appreciated... thanks...

> Hello all,

> We are currently using "sp_columns <table_name>" to find out the column
> names and data types for any given table.  Unfortunately, the sp_columns
> procedure is too slow for our purposes and is severely hindering our
> application (which is a perl script running on Apache mod_perl with
> DBI/DBD::Sybase).  Is there a faster way to just find out the column
> names and data types for a table?  Perhaps there are some internal
> tables we can query?  Or perhaps to write a striped down, more efficient
> version of sp_columns which only provides the bare bones information we
> need?

> Any help for this Sybase rookie appreciated... thanks...