Exam4Training

Which command below will only copy the table structure from the existing table to the new table?

Which command below will only copy the table structure from the existing table to the new table?
A . CREATE TABLE … AS SELECT
B. CREATE TABLE … LIKE
C. CREATE TABLE … CLONE

Answer: B

Explanation:

CREATE TABLE … LIKE

Creates a new table with the same column definitions as an existing table, but without copying data from the existing table. Column names, types, defaults, and constraints are copied to the new table: CREATE [ OR REPLACE ] TABLE <table_name> LIKE <source_table> [ CLUSTER BY ( <expr> [ , <expr> , … ] ) ]

[ COPY GRANTS ]

[ … ]

https://docs.snowflake.com/en/sql-reference/sql/create-table.html#create-table

Latest ARA-C01 Dumps Valid Version with 156 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version