Wednesday, May 22, 2013

Creating tables

Learned something new today ... or maybe came across something that I had forgotten ...
Create table from another table ...

The following 2 statements are the same

create table newtable as (select * from oldtable)

select * into newtable from oldtable

No comments :

Powered by Blogger.