![Free-eBooks.net](/resources/img/logo-nfe.png)
![All New Design](/resources/img/allnew.png)
→ Test-col2
against remove column
→ NEXT FINISH
10.05 How to create another table with the same set of column and data?
COPY table test-table-new to test-table-old
Through obJect Browser
Through sql command
Window
→ Tables
→ TEST-TABLE-NEW
→COPY
→ test-table-old in new table name
→ select all columns in
columns
→ select all rows against display
create table test-Table-old as
( select * from test-Table-new)
where will the option to copy selected rows, specific columns instead of * restricting columns