MS SQL server Meata data question

From: Tom Jones (tomjones_at_lucent.com)
Date: 01/13/04 

Date: Mon, 12 Jan 2004 18:32:36 -0500

I need to use php's native mssql api in order to read the meta data from an
entire DBMS ... I have sql server 2000 up and running and using the provided
browsing tools poked around and found that the databases in the system were
listed under a database named "master" in a table named "sysdatabases" ...
there is a "syscolumns" table there too but it looks like i need specific
info about the architecture of sql server's inner workings to use it.

the native php support for sql server doesn't have meta data functions like
are provided for things like mysql and odbc. I can't use adodb or pear for
alot of reasons ...

can anyone help me or point me to a souce for how to get:

databases -- I have done this one in a round about way
tables in those databases
attributes in those tables
and attribute types

I need to do this for Oracle too but I think the native support for Oracle
is better and the tools built in ... I think Oracle supports something they
call show commands that just do what I want.

Thanks
Tom

Relevant Pages

  • Re: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
  • Re: database dilemma
    ... > Dot net uses SQL Server and Oracle (check the help for the supported ... > versions) most efficiently as it has native drivers for these databases ... > Other databases use ODBC which work but with an overhead. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: database dilemma
    ... Dot net uses SQL Server and Oracle (check the help for the supported ... Other databases use ODBC which work but with an overhead. ... boss last week dropped vb.net on my desk and wants to create a web app and a ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Data access perfomance
    ... Sorry, I'm using Sql Server and Oracle 9i, on both databases the process is ... >> Databases and I fell like I've perfomance problems inserting into the DB. ... >> I insert the data after I've finished reading the xml file. ...
    (microsoft.public.data.oledb)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)