Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
How to Copy a Table structure, including all indexes?? |
Fri, Jun 5 2020 1:51 AM | Permanent Link |
Ian Branch | Hi Team,
I want to Copy a Table's structure to a new table with a different name. I need to include all fields, constraints & indexes. If I use the 'Create Copy of Table' in edbmgr it only copies the table and constraints. Is there a way? Regards & TIA, Ian |
Fri, Jun 5 2020 2:16 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Ian
In EDBManager open a new sql window, drag the table to be copied over. Then open the list to show indices (constraints should be in with the table definition) and drag them over one by one. Finally expand triggers and drag them over. Change the table name throughout and you should have all the sql you need to create the new table. Roy Lambert |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |