Create table from another table in TeraData database

Same Queries for Teradata DBs -


===========================================================================

	-- Without data
	CREATE TABLE new_table AS
	old_tables WITH NO DATA;

view raw crtTabNoDataTD.sql hosted with ❤ by GitHub

===========================================================================



===========================================================================

	-- Use the following SQL to copy table with data in Teradata:
	CREATE TABLE new_table AS
	old_table WITH DATA;
	-- The same results can be achieved by issuing the following statements:
	CREATE TABLE new_table AS old_table
	WITH NO DATA;
	INSERT new_table SELECT * FROM old_table;

view raw crtTabDataTD.sql hosted with ❤ by GitHub

===========================================================================

Create table from another table in Oracle database

Create table from another table in DB2 database

 

Like the Facebook Page & join Group
https://www.facebook.com/DataStage4you
https://www.facebook.com/groups/DataStage4you
https://twitter.com/datastage4you
https://groups.google.com/d/forum/datastage4you
For WHATSAPP group , drop a msg to 91-88-00-906098