Copying structure of table form one database to another

microsoft.public.sqlserver.programming

23 Mar 2006 5:49 PM

kevin.jonas

I am wondering if there is a simple way, like a stored procudure or
using some type of table object, to copy a table form one database to
another. Just the structure , index, triggers, I don't want the data.

24 Mar 2006 10:18 AM

Robert Klemme

kevin.jo***@gmail.com wrote:

> I am wondering if there is a simple way, like a stored procudure or
> using some type of table object, to copy a table form one database to
> another. Just the structure , index, triggers, I don't want the data.

You can generate a script for the whole schema with EM and execute it on
the target db. Maybe there's also a solution involving DTS - I'm not sure.

robert

24 Mar 2006 1:24 PM

Enric

Using DMO library also is possible and using DTS

--
Current location: Alicante (ES)

Show quote

"Robert Klemme" wrote:

> kevin.jo***@gmail.com wrote:
> > I am wondering if there is a simple way, like a stored procudure or
> > using some type of table object, to copy a table form one database to
> > another. Just the structure , index, triggers, I don't want the data.
>
> You can generate a script for the whole schema with EM and execute it on
> the target db. Maybe there's also a solution involving DTS - I'm not sure.
>
> robert
>