how to create a table from another table in sql derby

Solutions on MaxInterview for how to create a table from another table in sql derby by the best coders in the world

we are a community of more than 2 million smartest coders

registration for

employee referral programs

are now open

get referred to google, amazon, flipkart and more

showing results for - "how to create a table from another table in sql derby"

1CREATE TABLE my_new_table AS SELECT * FROM original_table WITH NO DATA;
2

1INSERT INTO my_new_table  SELECT * FROM orig_table.
2