Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848

    Unanswered: Information_schema

    Does sybase support SQL-92's Information_schema ??? Most of the other database servers do.
    Last edited by loquin; 04-01-08 at 14:51.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    Hello,

    As far as I know Sybase is not fully sql 92 compliant.

    Im guessing you are looking for something like this, and dont think this exists. Can you mention a little bit more of what you are trying to do, so that we can provide other means to do the same.


    The SQL Standard INFORMATION_SCHEMA, also known as the metadata or the system tables, is where you get to look at the definition of your database. It's not just tables (there are domains in it too plus all the predefined character sets / collations / translations), but the interesting things are in these tables, all of which can be accessed using:
    SELECT ... FROM INFORMATION_SCHEMA.table-name

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •