Home » SQL & PL/SQL » SQL & PL/SQL » while creating table copied all user defined constraints
while creating table copied all user defined constraints [message #7041] Sat, 17 May 2003 01:08 Go to next message
Firoz
Messages: 5
Registered: April 2003
Junior Member
dear all

i am creating one table using syntax "create table xx
as select * from yy". data and systems constraints
getting copied. i want to also copied all user defined
constraints. would u pls send me a systax.

feroz

Report message to a moderator

Re: while creating table copied all user defined constraints [message #7045 is a reply to message #7041] Sat, 17 May 2003 06:42 Go to previous messageGo to next message
Naveen
Messages: 75
Registered: June 2001
Member
Hi,

Could you be more specific of your requirement.

Regards
Naveen

Report message to a moderator

Re: while creating table copied all user defined constraints [message #7046 is a reply to message #7041] Sun, 18 May 2003 00:05 Go to previous message
Stacey
Messages: 5
Registered: September 2002
Junior Member
I dont think u can copy the constraints.It disables the constraints while creating the new table

Report message to a moderator

Previous Topic: star transformation
Next Topic: Rollback after truncate
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 05:36:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.