JuzerShakir/dup_table_without_data.sql

Created June 24, 2022 06:11

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/JuzerShakir/24526fecb3e38c3ad928c25bfc12b6e1.js"></script>
Save JuzerShakir/24526fecb3e38c3ad928c25bfc12b6e1 to your computer and use it in GitHub Desktop.

Download ZIP

Create a duplicate table from an existing table without any data:

Raw

dup_table_without_data.sql

	CREATE TABLE dup_countries
	AS SELECT *
	FROM countries
	WITH NO DATA;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment