title: How to get sybase table column name and its datatype and order by?
body: <p>There are multiple table in my sybase database. I want to know the column name and datatype of a given table like (myOrder table). How can I do this? Below script I found on stackoverflow <a href="https://stackoverflow.com/questions/1429898/from-a-sybase-database-how-i-can-get-table-description-field-names-and-types">From a Sybase Database, how I can get table description ( field names and types)? </a> . But this gives me exception <code>syscolumns is ambiguous</code>? The script is below that I used for this. </p>
  
  <pre><code>SELECT sc.* 
  FROM syscolumns sc
  INNER JOIN sysobjects so ON sc.id = so.id
  WHERE so.name = 'my_table_name'
  </code></pre>