freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
[freetds] [BUG] 0.91 SQL Anywhere SQLColumns,
Lionel Elie Mamane, 08/02/2012
-
Re: [freetds] [BUG] 0.91 SQL Anywhere SQLColumns,
James K. Lowden, 08/02/2012
-
Re: [freetds] [BUG] 0.91 SQL Anywhere SQLColumns,
Lionel Elie Mamane, 08/02/2012
- Re: [freetds] [BUG] 0.91 SQL Anywhere SQLColumns, James K. Lowden, 08/02/2012
-
Re: [freetds] [BUG] 0.91 SQL Anywhere SQLColumns,
Lionel Elie Mamane, 08/02/2012
-
Re: [freetds] [BUG] 0.91 SQL Anywhere SQLColumns,
James K. Lowden, 08/02/2012
Archive powered by MHonArc 2.6.24.