Skip to Content.
Sympa Menu

freetds - Re: [JDBC] DatabaseMetaData and the various servers

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Stefan Bodewig <bodewig AT bost.de>
  • To: <freetds AT franklin.oit.unc.edu>
  • Subject: Re: [JDBC] DatabaseMetaData and the various servers
  • Date: 14 Sep 2000 08:30:33 +0200


>>>>> "BK" == Bob Kline <bkline AT rksystems.com> writes:

BK> Ironically, Microsoft (and perhaps even the most recent
BK> version(s) of Sybase -- I don't know) is now doing the standard
BK> thing,

I was surprised to see SQL-92 (yes, INFORMATION_SCHEMA is *that* old)
conformant stuff myself 8^).

BK> but the approach which works across the widest combination
BK> of versions for both Sybase and MS SQL Server would be to use the
BK> system tables they have in common; i.e., sysobjects, systypes,
BK> sysusers, syscolumns, sysdatabases, etc.

Do you know where I could find a comprehensive list of these common
system tables - I mean which are there, not their content as I can
find this in my SQL Server 7 documentation myself?

I think we should base as many DatabaseMetadata methods as possible on
them instead of building our own temprorary tables.

Stefan




Archive powered by MHonArc 2.6.24.

Top of Page