Adrian Klaver <adrian.kla...@aklaver.com> escribió:
On 11/1/24 13:47, Thiemo Kellner wrote:It looks to me basically to be a "create table A as select * from B where false".No it more capable then that.
Yes, I wrote basically, not exactly.
CREATE TABLE <some_tbl> LIKE <some_other_tbl> has like_option which allows to transfer over more attributes of the table, for example defaults, constraints, indexes, etc.
But, to my understanding, no primary nor unique nor foreign constraint.
