This interesting post talks about the DEFAULT SQL statement is no longer a database constraint in SQL Compact 3.5. You merely use just DEFAULT.
To remove a default simply use SQL syntax: ALTER TABLE table ALTER COLUMN col DROP DEFAULT. This has always been the recomended way to remove defaults.
See here for more info: http://blogs.msdn.com/sqlservercompact/archive/2008/04/03/dropping-defaults.aspx
Thursday, May 15, 2008
Dropping Defaults (Column Constraint) in SQL Compact 3.5
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment