Details
-
Improvement
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
Description
Creating a table from existing table is very useful function for users. So, we should support CREATE TABLE LIKE The grammar is as follows:
CREATE TABLE <table_name> LIKE <source_table_name>
For reference, the LIKE clause specifies a table from which the new table automatically copies all column names, their data types.