CREATE AS Copies Table's Comment

Why it matters

This feature ensures that when creating a new table using the CREATE AS statement, the comment from the source table is preserved and copied to the new table. This helps maintain important metadata and documentation consistency across similar tables.

How to use it

When you create a new table using the syntax:

CREATE TABLE new_table AS existing_table

The comment from existing_table will automatically be copied to new_table without any additional steps.