OraFAQ Forum: SQL & PL/SQL » Replicate Table Structure

Home » SQL & PL/SQL » SQL & PL/SQL » Replicate Table Structure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Replicate Table Structure [message #239870]

Wed, 23 May 2007 09:04

marisa
Messages: 4
Registered: April 2007

Junior Member

hi guys is there any way to create table structure from existing

table without the table data of existing table.

please help me with this

thanks in advance

Report message to a moderator

Re: Replicate Table Structure [message #239873 is a reply to message #239870]

Wed, 23 May 2007 09:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

CREATE TABLE NEW_TABLE AS SELECT * FROM OLD_TABLE WHERE 1 = 2

Report message to a moderator

Re: Replicate Table Structure [message #239959 is a reply to message #239873]

Wed, 23 May 2007 14:10

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

CREATE TABLE ABC
AS
SELECT * FROM ABC_123
WHERE ROWNUM<1;

Report message to a moderator

Re: Replicate Table Structure [message #239967 is a reply to message #239959]

Wed, 23 May 2007 14:40

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

CREATE TABLE ABC
AS
SELECT * FROM ABC_123
WHERE ROWNUM<0;

CREATE TABLE ABC
AS
SELECT * FROM ABC_123
WHERE 2=3;

...

We can repeat ab finitum examples with impossible condition this does not bring anything more than the first answer.

Regards
Michel

Report message to a moderator

Previous Topic:	multiple values in a string causing stored procedure to hang even after commiting the data
Next Topic:	Difference between inner join and equijoin

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 07 00:24:44 CST 2024