Home » RDBMS Server » Server Administration » Check Constraint
Check Constraint [message #374820] Wed, 04 July 2001 23:47 Go to next message
Leo Lakota
Messages: 1
Registered: July 2001
Junior Member
Is posible to use function in Check Constraint

Report message to a moderator

Re: Check Constraint [message #374927 is a reply to message #374820] Thu, 12 July 2001 03:20 Go to previous messageGo to next message
murarishettysrinivas
Messages: 9
Registered: July 2001
Junior Member
yes ...
as long as the function does not try to generate new values each time

eg.
create table friends
( id number(2) primary key,
name varchar2(20) check (upper(name) = name));

Report message to a moderator

Re: Check Constraint [message #375077 is a reply to message #374820] Tue, 24 July 2001 04:54 Go to previous message
jj
Messages: 11
Registered: July 2001
Junior Member
how do I remove a check constraint from a field on a table (using the alter function?)

Report message to a moderator

Previous Topic: Null Value
Next Topic: Different Font
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 21:01:28 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.