• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • 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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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