Create an empty table with the same structure

Create an empty table with the same structure

Use Snowflake: its Snowflake Table API lets you create an empty table with the same structure in a single step (POST /api/v2/databases/{database}/schemas/{schema}/tables/{name}:create-like). capabilities.work can help you get signed up and connected.

• Can I create a new empty table that copies another table's columns but none of its data?
• What's the way to duplicate a table's structure without cloning its rows?

Say it to your AI assistant

• Create an empty table {name} with the same structure as this one.
• Copy this table's definition into a new, empty table called {name}.
• Make an empty table {name} with the structure of {table} in {database}.{schema}.

For your developer

POST /api/v2/databases/{database}/schemas/{schema}/tables/{name}:create-like in Snowflake Table API. Full spec on APIs.io.