Re: Which API will be appropriated for retireve the schema info of RDB

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Val Mazur (group51a_at_hotmail.com)
Date: 11/17/04 

Date: Wed, 17 Nov 2004 18:53:30 -0500

Hi,

You could use OpenSchema method of ADO connection. But, since ADO heavily
relies on a OLEDB providers capabilities to return information about
database, in some cases you will not get full schema information if provider
does not support functionality. 

-- 
Val Mazur
Microsoft MVP
"jim" <jim@discussions.microsoft.com> wrote in message 
news:4AACBCB8-5DA1-4555-BEEC-235A24EB4C07@microsoft.com...
> Hi All,
>
> I am going to develop a tool which is able to retrieve the schema
> information of RDBMS database, such as SQL Server or Oracle etc. Which API
> will be appropriate for this task? This tool will be used in Windows
> environment.
>
> My goals are that this tool will be used to retrive all the schema info, 
> not
> just part of the RDBMS database. It is pretty much like with the 
> enterprise
> manager of SQL Server.
>
> Thanks in advance!
> Jim
>

Relevant Pages

  • Re: Java is becoming the new Cobol
    ... In the Unisys 2200 environment using their Network Database Server, you get a schema work area depending on how you invoke the schema. ... However, it not only copies the schema area into the program, but the "DMCA" (Database Management Communication Area - basically, the block of information that holds your connection state) is copied in too. ... So, you're left with working-storage, which makes it visible to your program only, or common-storage, which makes it visible to programs linked in. ...
    (comp.lang.cobol)
  • Re: Renaming databse objects
    ... we may need to change the database name and in some cases want to rename ... existing database objects. ... Just in case this database object renaming project is in response to ... Create a new schema, ...
    (microsoft.public.sqlserver.programming)
  • Split messages
    ... This is based off the northwind database. ... Create document schema: ... Select the SQL entry, make sure that we are pointing to the SQL ... For the item select a receive pipeline and name it EmpSplitPipe.btp. ...
    (microsoft.public.biztalk.general)
  • Renaming databse objects
    ... While working on an existing database, we may need to change the database name and in some cases want to rename existing database objects. ... Just in case this database object renaming project is in response to ... Create a new schema, ... The schema with the original column names is still there, ...
    (microsoft.public.sqlserver.programming)
  • Re: Decouple SQL queries from class in OOP design
    ... > Of course there are existing applications that uses many different ... > architectures and still provides measurable business value. ... > should access every database directly. ... by the database, but the schema changes. ...
    (comp.object)