ASP script to display database structure?

microsoft.public.sqlserver.tools

6 May 2006 5:01 PM

Noozer

Does anyone have an ASP script that I can use to dump the structure of an MS
SQL 2000 database?

The firewall here won't allow any remote connections through and the DB host
does not have any web administrations?

I just need the table names, field names, and field data types.

Thx!

8 May 2006 1:00 PM

Keith Kratochvil

Why not use something like this?

SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH,
NUMERIC_PRECISION, NUMERIC_SCALE FROM information_schema.columns

--
Keith Kratochvil

Show quote

"Noozer" <dont.spam@me.here> wrote in message
news:%23uAs46ScGHA.3856@TK2MSFTNGP03.phx.gbl...
> Does anyone have an ASP script that I can use to dump the structure of an
> MS SQL 2000 database?
>
> The firewall here won't allow any remote connections through and the DB
> host does not have any web administrations?
>
> I just need the table names, field names, and field data types.
>
> Thx!
>