How to create table using another table in SQL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Atenza - 05 Mar 2008 01:39 GMT

hi,

How to create a new tableA from tableB by a single SQL?
I can't find from the book online, i remember that is possbile.

Thanks,
Martin

Reply to this Message

jason - 05 Mar 2008 01:47 GMT

Providing you don't want the data, you could do this.

select * into tableA
from tableB
where 1=2

Signature

Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio

> hi,
>
[quoted text clipped - 3 lines]
> Thanks,
> Martin

Reply to this Message

Rubens - 05 Mar 2008 02:04 GMT

That's a really neat trick! Why does the table creation happen regardless
of whether there is data inserted?

:-)

Rubens

> Providing you don't want the data, you could do this.
>
[quoted text clipped - 9 lines]
>> Thanks,
>> Martin

Reply to this Message

jason - 05 Mar 2008 02:27 GMT

SQL creates the table before it checks to see if 1=2 :) In a parallel
universe, it may...

Signature

Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio

> That's a really neat trick! Why does the table creation happen regardless
> of whether there is data inserted?
[quoted text clipped - 15 lines]
>>> Thanks,
>>> Martin

Reply to this Message

Uri Dimant - 05 Mar 2008 06:17 GMT

This technique does not create PK,FK on target table

> SQL creates the table before it checks to see if 1=2 :) In a parallel
> universe, it may...
[quoted text clipped - 18 lines]
>>>> Thanks,
>>>> Martin

Reply to this Message

Atenza - 05 Mar 2008 08:54 GMT

thx all

this is useful to create temp table for checking

> This technique does not create PK,FK on target table
>
[quoted text clipped - 20 lines]
>>>>> Thanks,
>>>>> Martin

Reply to this Message