Clone table - v8.0

Hello,

Is it possible to "clone" tables? We have a table with around 60 columns in it, and want to create a copy of that table but don't really want to do create one column at a time. Any way to get the table creation script for the existing table and modify the contents?

We don't want to clone the data in the table, just the schema

Thanks

Kin

Parents Reply
  • Thank you Trevor. Its the 1IM schema which I am interested in, I can clone the table on a SQL level but that is no good. 

    Is there some way to perform an auto update of the 1IM schema or is that required manually via schema extension tool? If the tool is required, then we might as well make the table manually isnt it?

    Thanks

    Kin

Children