| Can we rename a constraint [message #320507] |
Thu, 15 May 2008 05:41  |
manoj12
Messages: 210
Registered: March 2008
Location: India
|
Senior Member |
|
|
Dear Sir
When we create a table with columns having constraints for eg
create table xyz(x number(10) not null,y number);
when we use this command the table is created with x column having not null constraints and the constraint name appears to be default name like this SYS_CO053288.Can we rename the name of the constraint from SYS-O053288 TO NN_XYZ_ABC after creating the table?.If we can rename the name of the constraints how we can do?.
Regards
[Updated on: Thu, 15 May 2008 05:42] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
