odps-table:tldr:fa3ee

odps-table: Create a table based on the definition of another table.

create

$ create table ${table_name} like ${another_table};

try on your machine

This command is used to create a new table in a database, with the structure or schema similar to an existing table.

${table_name} represents the name of the new table that you want to create.
like is a keyword used to indicate that you want to create the new table based on the structure of another table.
${another_table} is the name of the existing table whose structure you want to replicate.

By executing this command, a new table named ${table_name} will be created in the same database, with the same columns, data types, constraints, and indexes as ${another_table}. However, the new table will not have any data.

This explanation was created by an AI. In most cases those are correct. But please always be careful and never run a command you are not sure if it is safe.

back to the create tool