Can anyone explain to me what the following alter command does?

Thanks

-------------------------------------------
ALTER TABLE [dbo].[SSR] WITH NOCHECK ADD
    CONSTRAINT [DF_SSRFACC_BAD_DEBTOR_FLAG] DEFAULT ('N') FOR [BAD_DEBTOR_FLAG],
    CONSTRAINT [DF_SSRFACC_DATE] DEFAULT ('1/1/1900') FOR [DATE_FOR_ACTION],
    CONSTRAINT [DF_SSRFACC_DATE_PAID] DEFAULT ('1/1/1900') FOR [DATE_PAID]
GO

It adds default constraints to the table SSR.

A default constraint is a value which is automatically provided to the indicated column if no value is provided on an INSERT query.

These constraints are added with the NOCHECK option, so the defaults will not be applied to any existing data; they will only be in effect for new rows added.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com