Re: Help: Copy tables and indexes to another user

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 > think you are going to have to re-name the indexes on the copy, because > index names are unique across the entire database. > > Cheers, > -- > > Mark. > > +-------------------------------------------------------------------------+ > |Mark D. Stock - The West Solutions Group http://www.west.co.za | > | | > |mailto:marks@west.co.za +------------------------------------------------+ > |Tel: +27 11 803 2151 |If it doesn't work... force it! | > |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | > |Cell: +27 83 250 2325 |Well, that's how I code anyway! | > +------------------------+------------------------------------------------+ Hi Mark ! This is Mister Bug(gy) calling again! Your answer is right. Index names have to be unique within a database. I have taken a closer look at the manuals again and it's all there ! Thanks a lot! Dirk --------------------------------------------------- Dirk Schmidtpott S I E M E N S EMail: schmd@dbm212.pdb.sni.de ============= Phone: 0049-5251-8-14922 N I X D O R F Fax : 0049-5251-8-27905 The above statements and opinions are my own and do not necessarily represent those of my employer. ---------------------------------------------------