I'd like to SELECT INTO one table into another one. However, I'd like to do two things that I don't know how to do using SELECT INTO:
1. Copy over the indexes and constraints of the first table into the second
2. Do SELECT INTO even if the second table already exists.
Is there anyway to do either one of those?
Failing that, is there a way to copy a table's schema - its columns, indexes, and constraints - into a new (empty) table?
