creating an exact replica of another table in SQL 7.0

[sandra64]

Hi

In ingres sql you can type the command:-

create table tt2 as
select * from tt1

table tt2 will then be created with exactly the same properties etc as tt1.

Is there an equivalent in SQL version 7.0.

also in ingres you can do the following command :-

insert into tt2
select * from tt1

which will put all the rows from tt1 into tt2 (if the tables are identical)

is there an equivalent to this....

Not to worry if there isn't, I'll just have to do it the long winded way, I just used to find those two very useful.

cheers
Sandra

 

[JohnDTampaBay]

Your second scenario is exactly the same in SQL as ingres.

insert into tt2 select * from tt1

The SQL equivalent to

create table tt2 as select * from tt1

would be

select * into tt2 from tt1

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[sandra64]

Angel

you are an angel

thanks alot

Sandra