• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

How do I export my table design, not the data, in sql server 2000?

I need to export my table design in to an excel sheet. I need column name, data type, length, etc. Not interested in the data. I have looked at the DTS agent to see if this could do it, but does not seem to be a tool to do it. To bad I can copy paste in to an xls. I'm using server 2000
0
dawes4000
Asked:
dawes4000
1 Solution
 
chapmandewCommented:
In EM, you can right click the DB, select generate sql scripts, then select show all, and select all tables/objects you want to script out...
0
 
dawes4000Author Commented:
chap,
I've done this before. I need something more than a note pad version. Preferably an export to excel with column headers and such.
0
 
nmcdermaidCommented:
Can you be more specific? Do you want some nice formatting or something? Based on your current spec, the solution is to take the SQL script and paste it into Excel.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Anthony PerkinsCommented:
Perhaps something like this:

Select COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH
From INFORMATION_SCHEMA.COLUMNS
Where TABLE_NAME = 'YourTableName'
Order By ORDINAL_POSITION

You can explore the other columns available.
0
 
chapmandewCommented:
Or this...although you'd need 2005:

http://blogs.techrepublic.com.com/datacenter/?p=431
0
 
dawes4000Author Commented:
Ace,
yes, the query was exactly what I was looking for. A custom query in DTS to an excel sheet. Thanks.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now