ASP/SQL code for showing all DB info...

[Holden Caulfield]

Hi there,
I need some ASP/SQL code that will show the complete structure of a
database. That is, all the exisiting table names, and all fields (and
filed types) in those tables.

Why?

Because I am in a situation where I need to make major mods to an
existing site that uses a SQL database without having any of the
documentation about the database! I have no tools at my disposal,
except what I can make myself through my ASP code and the db
connection string. I don´t even know where the db exists! (It is a
long story, so I will stop there...)

There must be code that will show the database blueprint, which is the
first step in me getting started...

Thanks,

Holden

[Bob Barrows]

Holden Caulfield wrote:

> Hi there,
> I need some ASP/SQL code that will show the complete structure of a
> database. That is, all the exisiting table names, and all fields (and
> filed types) in those tables.
>
> Why?
>
> Because I am in a situation where I need to make major mods to an
> existing site that uses a SQL database without having any of the
> documentation about the database! I have no tools at my disposal,
> except what I can make myself through my ASP code and the db
> connection string. I don´t even know where the db exists! (It is a
> long story, so I will stop there...)
>
> There must be code that will show the database blueprint, which is the
> first step in me getting started...
>
> Thanks,
>
> Holden

What kind of SQL database? SQL Server? What version? Access? What version?
Oracle? ....

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Aaron Bertrand [MVP]]

> I need some ASP/SQL code that will show the complete structure of a

> database. That is, all the exisiting table names, and all fields (and
> filed types) in those tables.

[url]http://www.aspfaq.com/2177[/url]
[url]http://www.aspfaq.com/2178[/url]

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]

[el.c. - myLittleTools.net]

> Hi there,

> I need some ASP/SQL code that will show the complete structure of a
> database. That is, all the exisiting table names, and all fields (and
> filed types) in those tables.

Free lite edition of myLittleAdmin can help you :
[url]http://www.myLittleTools.net/mla_sql[/url]

hth
el.c.

--
// myLittleTools.net : leading provider of web-based applications.
// myLittleAdmin WebHosting Edition is now available
// [url]http://www.mylittletools.net[/url]
// [email]webmaster@mylittletools.net[/email]

>
> Why?
>
> Because I am in a situation where I need to make major mods to an
> existing site that uses a SQL database without having any of the
> documentation about the database! I have no tools at my disposal,
> except what I can make myself through my ASP code and the db
> connection string. I don´t even know where the db exists! (It is a
> long story, so I will stop there...)
>
> There must be code that will show the database blueprint, which is the
> first step in me getting started...
>
> Thanks,
>
> Holden

[Roland Hall]

"Holden Caulfield" wrote:

> Hi there,
> I need some ASP/SQL code that will show the complete structure of a
> database. That is, all the exisiting table names, and all fields (and
> filed types) in those tables.

This allows you to see structure, data and make modifications, including
stored procedures.
[url]http://www.standardreporting.net/1ClickDB/default.aspx[/url]

>I don´t even know where the db exists! (It is a
> long story, so I will stop there...)

How can you make an ADODB connection without knowing where the database is?
SQL is usually on a separate server and accessing it in ASP will identify
the FQDN or the IP.

--
Roland

This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose.