-
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
-
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|