Try sp_columns, we actually modified the stored procedure to spit out only
the columns we wanted.
Casey Cook
"Bosky, Dave"
<Dave.Bosky To: SQL <[EMAIL PROTECTED]>
@htcinc.net> cc:
Subject: RE: Print out tables in MS SQL
2000
01/21/03 09:19
AM
Please respond
to sql
I've tried that but when I execute the stored procedure in query analyzer
it
only prints out the sql statement.
How can I print the results panel instead?
Thank You,
Dave Bosky
~Sr. Multimedia Web Designer
~HTC Web Services
~[EMAIL PROTECTED]
~office: 843.369.8613
-----Original Message-----
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 10:13 AM
To: SQL
Subject: RE: Print out tables in MS SQL 2000
sp_help {objectname}
i.e. sp_help products
-----Original Message-----
From: Bosky, Dave [mailto:[EMAIL PROTECTED]]
Sent: 21 January 2003 14:48
To: SQL
Subject: Print out tables in MS SQL 2000
What's the best method of printing out the table
structures(fieldname/datatype) of a database?
I've tried the print screen method but is there a better way?
Thank You,
Dave Bosky
~Sr. Multimedia Web Designer
~HTC Web Services
~[EMAIL PROTECTED]
~office: 843.369.8613
HTC Disclaimer: The information contained in this message may be
privileged
and confidential and protected from disclosure. If the reader of this
message is not the intended recipient, or an employee or agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer. Thank you.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
