Documenter

In Access you can analyze tables and use the documenter to
write out all of the tables with their permissions, column
names, data types etc. Is there a way to do this in SQL
Server?Hi Tammy
SQL 2000 and earlier does not have a tool like Access documentor.
You can run sp_help with a table name as a parameter and view the same
information. Information Schema Views might also be used to build your own.
If you want to save a copy of the scripts used to rebuild your objects, you
can script all the objects in a SQL Server database. (Right click on the
database, All Tasks, Generate SQL Script...)
Nick Schueler
| Content-Class: urn:content-classes:message
| From: "tammy" <tammy@.urban.csuohio.edu>
| Sender: "tammy" <tammy@.urban.csuohio.edu>
| Subject: Documenter
| Date: Fri, 20 Feb 2004 07:30:18 -0800
| Lines: 4
| Message-ID: <1310201c3f7c6$71e90df0$a101280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcP3xnHpbT3GZ9OEQZKEzULTHYNYMg==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.sqlserver.datawarehouse
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.datawarehouse:18909
| NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
| X-Tomcat-NG: microsoft.public.sqlserver.datawarehouse
|
| In Access you can analyze tables and use the documenter to
| write out all of the tables with their permissions, column
| names, data types etc. Is there a way to do this in SQL
| Server?
|