default constraint

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Patty O'Dors (PattyODors_at_discussions.microsoft.com)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 03:39:03 -0700

is there any SQL that can be fired off against Access that will cause it to
apply a default to a particular column?

using

alter table mytable add constraint myconstraint default (0) for mycolumn

doesn't seem to work, either over ADO or within Access.

Any ideas?

Relevant Pages

  • default constraint
    ... is there any SQL that can be fired off against Access that will cause it to ... alter table mytable add constraint myconstraint default for mycolumn ... either over ADO or within Access. ...
    (microsoft.public.vb.general.discussion)
  • default constraint
    ... is there any SQL that can be fired off against Access that will cause it to ... alter table mytable add constraint myconstraint default for mycolumn ... either over ADO or within Access. ...
    (microsoft.public.sqlserver.programming)
  • default constraint
    ... is there any SQL that can be fired off against Access that will cause it to ... alter table mytable add constraint myconstraint default for mycolumn ... either over ADO or within Access. ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: [Info-ingres] Re: Pagesize question
    ... d0delim format on the copy INTO (See SQL ref Guide). ... ALTER TABLE is initially quick but there are also other performance issues ... I've written a Ruby adapter for the Ingres ... Ruby on Rails comes with a set of automated tests that ensure a database ...
    (comp.databases.ingres)
  • Re: Using parameters with the low level ADO API, trying to avoid the memory leaks.
    ... MS ADO passes SQL directly to OLEDB provider. ...
    (borland.public.delphi.database.ado)