At 09:08 PM 9/13/2000 -0400, Claudio Valderrama C. wrote:

> In this case, MsSql's defaults are only values. I read in the
>online books:
>«
>Defaults, a backward compatibility feature, perform some of the same
>functions as default definitions created using the DEFAULT keyword of ALTER
>or CREATE TABLE statements.
>»
> So probably a default alone should be deprecated in favor of what
> MS calls
>"default definitions" that are no more than the DEFAULT keyword inside a
>CREATE TABLE command. In this regard, IB's domains provide both
>functionalities: they are reusable across table definitions and they are
>defined only one. This is the reason I think both User Defined Datatypes and
>Default alones (made by CREATE DEFAULT) in MsSql should be mapped to IB
>domains.

I believe that defaults, as implemented by IB6.0 follow the standard
syntax. I also believe that the V6 implementation is seriously flawed
and wouldn't use it.

Ann