Re: Copying table Structure from one server to another

#1

The simplest method is to use Query Analyzer. In the object Explorer, keep
expanding until you get down to the table, and then [Right-Click] on the
table and select [Script Object to file as...], [ CREATE]. (or window, or
clipboard.)

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

"kiran" <kiran.gazz (AT) gmail (DOT) com> wrote

Quote:

Hi all,
I have a small problem. I want to create a table Say
"tab1" from Server A into Server B. I dont want to copy the whole
table.I just want a "create table" String which is derived from tab1 of
server A. I want this to be simple.
Is there any soln.
Thanks,
Kiran G

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Copying table Structure from one server to another

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Copying table Structure from one server to another - 09-06-2006 , 09:36 AM