25112
asked on
default constraint within a function
in sys.all_objects I see some default constraints, whose parent object is a function.. what syntax can be used to create such within a UDF?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
can you define the name of the default constraint in the code block? (so that when you do a search on sys.all_object where parent_id=UDF_id
then we see meaningful entries..
(just to clarify, i would refer to type ='d' in sys.all_objects..)