Is there a way to retrieve the value associated with a default object in 11.92.

Something like:

create default dbo.def_person as 1
go

declare @def_person_id numeric(6)

select @def_person_id = value from syssometable where name='def_person'

Thanks in advance

Jim

"Jim" <james.wright (AT) ubsw (DOT) com> wrote


You can query syscomments and extract the default value from there.
Keep in mind however, that line breaks in the original 'create
default' statement will be preserved in syscomments (so don't expect
it to be a single text string without newlines).

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of "Tips, Tricks & Recipes for Sybase ASE" and
"The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------