How to use a SQL query to document your database

Did you know that you can use a SQL query to document your SQL Server 2000 database? This simple query on the system tables will do just that. You can easily cut and paste the results into a Word document and improve the look and feel. Imagine the amount of typing you will save! I used this SQL query to document a 100 table database in a couple of seconds. The code has been tested on SQL Server 2000 and should work even on SQL 7.0.

Reader Feedback

Kelly B. writes: Companies that have their own data types defined may cause multiple uses of a single xtype in the sys...

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Microsoft SQL Server Using the Visual Studio 2005 DataSet Designer to build a data access layer The CTE, the hierarchical query and SQL Server 2005 SQL Server 2005 recursive functions and the CTE Choose the right .NET data provider, optimize application performance The fallacy of the data layer -- or, a new architectural model for software designs Book excerpt: ADO.NET and SQL Server 2005 Addressing common SQL Server questions Book Excerpt: The .NET Framework and SQL Server 2005 WinForms development using SQL Server 2005 and Visual Basic 2005 Configuring ASP.NET 2.0 apps to SQL Server 2005 databases SQL Server and .NET development Microsoft releases new CTP of Oslo SDK Perpetuum unveils database synchronizer for .NET 2.0 The CTE, the hierarchical query and SQL Server 2005 SQL Server 2005 recursive functions and the CTE SQL Examiner Suite synchronizes data schema, sets Book excerpt: ADO.NET and SQL Server 2005 DataDirect database drivers now support MySQL Top .NET tips of 2007 (so far) Addressing common SQL Server questions Book Excerpt: The .NET Framework and SQL Server 2005

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

types table, thus causing too many rows returned (i.e., more than one row per column in a table) However if you use the xusertype in the SQL query you may come up with a more accurate answer.

I came up with 147675 rows.

I came up with the appropriate 7080 rows.

Robert H. writes: What's the point? To script tables and/or indexes, logins, users, permissions, etc. in MS SQL 7.0 or MS SQL 2000 (and as far back as v. 6.5 I think), simply right-click on a database, select 'All Tasks', and select 'General SQL Script'.

Lowell S. writes: Try this one-liner:

Rate this Tip To rate tips, you must be a member of SearchWinDevelopment.com. Register now to start rating these tips. Log in if you are already a member. Submit a Tip DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.