Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

oracle sql copy table without data

-- Copy datas and structure:
CREATE TABLE new_table AS SELECT * FROM my_table;
-- Copy structure only:
CREATE TABLE new_table AS SELECT * FROM my_table WHERE 1=0;
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #oracle #sql #copy #table #data
ADD COMMENT
Topic
Name
5+3 =