Hi all.

When I'm talking to MySQL, I can easily get the default for a column
from the COLUMN_DEF key from column_info.
However when I'm talking to SQL Server, it doesn't return an actual
value, but a 'create default' statement such as:

CREATE DEFAULT dbo.Contacts_Salutations_D AS 'Mr'

Is there anything available that will parse this for me and return the
actual value?
I realise I can just grab the stuff in quotes, but I'm just checking if
there is a better way.

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au

Reply via email to