I've created a table like so:
create table doki_data_item2 (like doki_data_item including defaults);
but this new table uses the same sequence as the old table.
So two questions:
- How can I copy and table and the necessary sequences easily?
- How can I replace a sequence on one table with another sequence?