Wht is different between COPY option in SQL and create table new_table as select * from table_1

Interview Candidate
Aug 1st, 2006
1
1729

First
Prev
Next
Last

Showing Answers 1 - 1 of 1 Answers

Ramprasad

Dec 14th, 2006

Hi,
Through Copy command in SQL will copy a table with Data like a normal COPY command in MS-DOS.
In SQL, CREATE statement will provide flexibility to copy complete structure or partial and structure along with selected rows(DATA) or complete rows.
Hope you got it.
-Ramprasad K
HCL Technologies.