Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
| Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 15th, 2004, 04:10 PM
Registered User
 
Join Date: Mar 2004
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Printing of Table structure

Hi all,

I trying to find an easy way to print out all of the tables and their structures in SQL Server Enterprise Manager for easy reference when programming SQL in VC++.

TIA..

Jim

 
Old July 15th, 2004, 06:08 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: High Wycombe, UK, United Kingdom.
Posts: 344
Thanks: 0
Thanked 1 Time in 1 Post
Default

You can script the database up as one of the export functions - if i recall correclty - this will give you the structure. For the data, just do a SELECT * in Query Analyser and then print your results.
 
Old July 15th, 2004, 06:20 PM
Registered User
 
Join Date: Mar 2004
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Greg, I found the "Generate Script" and have used that, just thought there might have been a little better printout of the Table structure.

Thanks,

Jim

 
Old July 16th, 2004, 12:49 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi Jim,

You can also create a new Diagram which you'll find under your database in the Enterprise Manager, right above Tables. Right-click and choose New Database Diagram.

A Diagram allows you to add one or more tables (visually) to a designer surface. You'll be able to see table names, column names, relations, data types etc. If you want more details about a table, right click it and choose Table View | Custom and then right-click again and choose Table View | Modify Custom to select the information you want to see.
Changes you make to the table and relations will be applied to the underlying tables when you save the Diagram.

Be prepared that the Print functionality is a bit buggy. Expect the paper orientation to switch between Portrait and Landscape at will, for example ;)

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old July 16th, 2004, 01:26 AM
Registered User
 
Join Date: Mar 2004
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Imar,

I'll give that a try and see if it's any better than reading script.

Jim





Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy whole structure of table in #temp table maulik77 SQL Server 2000 2 December 21st, 2006 02:42 AM
Copy table structure sagarbhargava SQL Server 2000 3 November 16th, 2006 03:16 AM
Splitting Table into more efficient structure MauiSpud Access 7 May 12th, 2006 07:35 AM
change table structure Duncan SQL Server 2000 1 March 3rd, 2005 04:10 AM
Table / DB Structure mtangorre SQL Server 2000 1 June 27th, 2003 01:32 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.