Home > Archive > MS SQLCE > October 2005 > Default values in a database









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Default values in a database
Vladimir Oľura

2005-10-27, 7:53 am

How can I get the default value for a given column in a given table and set
it for a column in a dataTable?


Darren Shaffer

2005-10-27, 7:53 am

Did you try the INFORMATION_SCHEMA.COLUMNS view?
I'm not sure if the metadata returned includes default values but
that's where I would look first.

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com


"Vladimir Oľura" <vladimir.ozura@fer.hr> wrote in message
news:djgoih$iiu$1@ba
gan.srce.hr...
> How can I get the default value for a given column in a given table and
> set
> it for a column in a dataTable?
>
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com