Re: [BUG] 0.91 SQL Anywhere SQLColumns
"James K. Lowden" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
On Thu, 2 Aug 2012 18:13:57 +0200 Lionel Elie Mamane <[email protected]> wrote: > > Sybase supports INFORMATION_SCHEMA nowadays, too. How long has that > > been true? Is there any reason to test a server and fall back to > > sp_columns? > > SQL Anywhere 10 does not, or am I making something wrong? I don't know where I got that impression. A more thorough search shows Sybase doesn't support INFORMATION_SCHEMA. > OTOH, the SYS schema looks interesting; the data will need some > sorting / column reordering / column renaming / post-processing, but > at least some of the information seems to be there. So, yes, the query would have to be written in terms of the system tables. I think you'll find in fact that everything you need is there. --jkl