How do I get db ddl properties from sql 2000 like documenter does in MS Access?

Hi,
I am looking for an easy way to get all of the properties from a SQL 2000
database much like the documenter does in MS Access. Any ideas?Not all of us use Access. Can you tell us what it is that you want?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"NOSPAM" <NOSPAM@.shaw.ca> wrote in message
news:nP4Cb.667338$9l5.552044@.pd7tw2no...
> Hi,
> I am looking for an easy way to get all of the properties from a SQL 2000
> database much like the documenter does in MS Access. Any ideas?
>|||Perhaps you can use the INFORMATION_SCHEMA views. This should get you =started:
SELECT * FROM INFORMATION_SCHEMA.TABLES SELECT * FROM INFORMATION_SCHEMA.COLUMNS
More info on these views can be found within Books Online (within the =SQL Server program group).
-- Keith
"NOSPAM" <NOSPAM@.shaw.ca> wrote in message =news:nP4Cb.667338$9l5.552044@.pd7tw2no...
> Hi,
> > I am looking for an easy way to get all of the properties from a SQL =2000
> database much like the documenter does in MS Access. Any ideas?
> >|||Ok, I take back, swag sucks! I just ran the app and I must say this is a DBA
's dream come true! Especially for a person like me that is a coder by trade
and forced to maintain SQL db's due to the client's small budgets. The plain
and simple fact is, in the five minutes it took to run the application, it
paid for itself ten times over. I love it! I recommend it to everybody.
Get Yours...
http://ag-software.com/ags_scribe_index.aspx
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:%23zQ8CoCwDHA.2880@.tk2msftngp13.phx.gbl...
Perhaps you can use the INFORMATION_SCHEMA views. This should get you
started:
SELECT * FROM INFORMATION_SCHEMA.TABLES
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
More info on these views can be found within Books Online (within the SQL
Server program group).
--
Keith
"NOSPAM" <NOSPAM@.shaw.ca> wrote in message
news:nP4Cb.667338$9l5.552044@.pd7tw2no...
> Hi,
> I am looking for an easy way to get all of the properties from a SQL 2000
> database much like the documenter does in MS Access. Any ideas?
>