Support create table xxx like yyy

[Gump9]

What problem does the new feature solve?

When i migrate tests from DuckDB,I found that we don't support this statementcreate table xxx like yyy,now we must use show create table yyy statement first,and then copy the create statement of yyy to create xxx.Should we support this statement?
It seems that we can't copy constraint from yyy to xxx when we use create table xxx like yyy directly :

What does the feature do?

Support statement create table xxx like yyy

Implementation challenges

No response

[killme2008]

It's a useful feature, let's move it to the following release plan.

[KKould]

I want to try to implement this

[tisonkun]

@KKould this feature is nontrivial. What's your plan in implementing it?

[KKould]

@KKould this feature is nontrivial. What's your plan in implementing it?

I originally planned to refer to Statement::ShowCreateTable to get TableInfo to get CreateTableExpr and then call StatementExecutor:::create_table_inner. However, if this feature is important, I would be better off looking for some less important issues.

[waynexia]

Sounds good. Let me assign it to you

[KKould]

Sounds good. Let me assign it to you

I'll try to implement it this weekend