On Nov 3, 2006, at 6:35 PM, der.hans wrote:
>> Any tips on creating a new table and indexes based on another
>> table and
>> its indexes?
To create a new table based on an existing one, you can to this :
"CREATE TABLE new_table LIKE old_table"
This is just the column and index information. If you also want the
data, next do : "INSERT INTO new_table SELECT * FROM old_table"
regards,
alex
.
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)