How do you print the fieldnames and datatypes in a
table? I know there's a way because I've done it...but can't remember and
don't see an option in the menu choices...thanks...Jan

Hi,
Did you mean just display, then

select table_name,data_type,character_maximum_length from
information_schema.columns
where table_name='tablename'

otherwise

sp_columns tablename

Thanks
Hari
MCDBA

"J Harrigan" <jlharrigan (AT) hotmail (DOT) com> wrote

try
EXEC sp_columns @table_name = 'name of table

----- J Harrigan wrote: ----

How do you print the fieldnames and datatypes in
table? I know there's a way because I've done it...but can't remember an
don't see an option in the menu choices...thanks...Ja

You asked this yesterday I believe

I gave you a number of ways then but the way I believe you want is

Right click on the object | All Tasks | Generate SQL Script

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"J Harrigan" <jlharrigan (AT) hotmail (DOT) com> wrote

Yes...your response wasn't there when I looked this morning but it IS there
now...THANKS again!

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote