Interpreting COLUMN_DEF from column_info
am 02.06.2006 03:33:01 von dkasakHi 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: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au