Skip to Content.
Sympa Menu

freetds - Re: [freetds] [BUG] 0.91 SQL Anywhere SQLColumns

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] [BUG] 0.91 SQL Anywhere SQLColumns
  • Date: Thu, 2 Aug 2012 15:54:26 -0400

On Thu, 2 Aug 2012 18:13:57 +0200
Lionel Elie Mamane <lionel AT mamane.lu> 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






Archive powered by MHonArc 2.6.24.

Top of Page