Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: create a new duplicate table
12-17-2003, 02:51 PM #1
create a new duplicate table
I want to create a table identical to the first table but with no data in.
With Oracle SQL i usually do this
CREATE TABLE newTable AS ( SELECT * FROM exisitingTable )
12-17-2003, 03:19 PM #2
- Join Date
- Jul 2002
- Thanked 0 Times in 0 Posts
SELECT oldtable.* INTO newtable FROM oldtable