Re: Adding SHOW CREATE TABLE

[Ron <ronljohnsonjr@xxxxxxxxx>]

    On 5/12/23 18:00, Kirk Wolak wrote:
>       
>     
    [snip]

Where do we draw the lines?

    At other tables.

Does Table DDL include all indexes?

    Absolutely!

It should include constraints, clearly.  I would not think it should have triggers.

    Definitely triggers.  And foreign keys.

Literally everything within the <<CREATE TABLE X(...);>>.  (ie, no ALTER .. OWNER TO...)

    ALTER statements, too.  If CREATE TABLE ... LIKE ... { INCLUDING |
    EXCLUDING } { COMMENTS | COMPRESSION | CONSTRAINTS | DEFAULTS |
    GENERATED | IDENTITY | INDEXES | STATISTICS | STORAGE | ALL } can do
    it, then so should SHOW CREATE TABLE.

--
Born in Arizona, moved to Babylonia.