Re: Help: Copy tables and indexes to another user
Alter table and use EXPLICIT Contraint NAMES for RI. Lot of work by hand,ZTOOLS does it QUICKLY. Check them out! Striping it from the table and
making it into an Alter TABLE statement. Try one or Two Tables and See if
it works for you! If so, doing it per user on a DB with many user's ZTOOLS
will pay for it self in the time you save!
Hope this Helps!
-------------------------------------------------------------------------
Cheryl Kendricks
Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov
DTSI, Inc.
Database Administrator - DOL Job Corps San Marcos, Texas
------------------------------------------------------------------------
On
Tue, 16 Jul 1996, Dirk Schmidtpott wrote:
> Mark D Stock wrote:
> >
> > I presume you are copying a table to the same database. I'm not that clued
> > up on ANSI databases, they privide too many cons and no pros. However, I
......[SNIP]
>
> Hi Mark !
>
> I know, that it's not a very elegant way to handle multiple users. But that's
>
[SNIP]