OraFAQ Forum: SQL & PL/SQL » Create table from existing table

Home » SQL & PL/SQL » SQL & PL/SQL » Create table from existing table

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

Create table from existing table [message #822]

Wed, 06 March 2002 05:26

Saravanan Veerappan
Messages: 1
Registered: March 2002

Junior Member

I need to create a new table as same table structure as existing table with constraints.Then i need to drop existing table. When i use create table tableA as select * from tableB, it creates table without copying constraints.

I appreciate your help.

Report message to a moderator

Re: Create table from existing table [message #823 is a reply to message #822]

Wed, 06 March 2002 05:54

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

u have to create constraints manually. if u r not sure what are the contraints then see user_constraints and user_cons_columns, which keeps information about the constraints

Report message to a moderator

Previous Topic:	Sequence numbers in SQL or Stored Procedure
Next Topic:	how to generate random records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 11 14:38:53 CDT 2025