Re: MS SQL server Meata data question
From: Chung Leong (chernyshevsky_at_hotmail.com)
Date: 01/14/04
- Next message: Ed Seedhouse: "Re: Check my math!"
- Previous message: NotGiven: "how can I count the number of seconds a page is viewed?"
- In reply to: Tom Jones: "MS SQL server Meata data question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 13 Jan 2004 20:49:50 -0500
Call the store procedure sp_databases and sp_tables to get a list of
databases and tables (in the current database). sp_columns will get your a
list of a table's columns. Look in your MS SQL help file for more info.
Uzytkownik "Tom Jones" <tomjones@lucent.com> napisal w wiadomosci
news:btvarb$9sb@netnews.proxy.lucent.com...
> 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
>
>
- Next message: Ed Seedhouse: "Re: Check my math!"
- Previous message: NotGiven: "how can I count the number of seconds a page is viewed?"
- In reply to: Tom Jones: "MS SQL server Meata data question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
