how to write script to copy table structure only

Hi, All
I need to create a empty table which is a copy of an existing table structure including primary keys etc.,
but my testing database is MSDE, no enterprise manager, can you tell how to do it. Oracle statement won't work here.
Thanks
Betty

http://www.databasejournal.com/featu...le.php/2205291

Thanks, MAK, that's good resource.
After I generated script and I put it under my documents dir, use cmd window to execute generatetable.sql.
I typed :
osql -E
use CMC
go
generatetable
go
it keeps coming up message with
"could not find store procedure generatetable or generatetable.sql
why?
Betty

You have to pass the file as input parameter

osql -E -dCMC -igeneratetable.sql -Sservername

Thanks, MAK, that's good resource.
After I generated script and I put it under my documents dir, use cmd window to execute generatetable.sql.
I typed :
osql -E
use CMC
go
generatetable
go
it keeps coming up message with
"could not find store procedure generatetable or generatetable.sql
why?
Betty

skhanal,
Thanks you so much for your reply. You replied a few of my threads already, and you really make my life much easier. I work in a small company where resources are very limited. You just never know how much I appreciated your contribution to this board.
Betty

BTW that article was written by SKhanal.

I am blind. When I looked at the author of this article, I just feel so familiar, it looks like...never aware it is him until now.
Thanks for telling me.
Betty

Glad to be of help :)