Print Table Definition 1

[pthalacker]

Is there a way to print a table definition from the Enterprise Manager, or do I have to pull the information to a front end?

pamela

 

[mrdenny]

I don't think that Enterprise Manager includes a way to print the modify table schema screen.

You can query the information from the INFORMATION_SCHEMA.COLUMNS view.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ptheriault]

If you have Query analyzer run sp_help 'table_name'.
you can send the outout to a file then print it.


- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[pthalacker]

run sp_help 'table_name'.
you can send the outout to a file then print it.

Rudimentary, but satisfies the requirement.

Thanks, Paul.

 

[MrPlough69]

Also, a nice handy shortcut in Query Analyzer is to highlight the table name, then press Alt+F1.