Set Field's Default Value
Sorry Tibor
I think I pressed the wrong reply button.
Hi
As in the SQL Help, it seems that you can only set the field default value
by adding a new field rather than modifying existing field default value??
Kevin
Quote:
> BOL = Books Online. You find it in the SQL Server program group.
> --
> Tibor Karaszi, SQL Server MVP
> FAQ from Neil at: http://www.sqlserverfaq.com
> Please reply to the newsgroup only, not by email.
Quote:
> > Hi Dave
> > What is BOL?? I looked at the T-SQL help but could not find it.
> > Kevin
> > > yes, see BOL under ALTER TABLE (T-SQL)
> > > --
> > > HTH,
> > > David Satz
> > > Principal Software Engineer
> > > Hyperion Solutions
> > > ->Using SQL Server 7.0 SP3/6.5 SP5a/Cold Fusion 4.5.1 SP2/VSS
> > > (Please reply to group only - emails answered rarely)
> > > -----------------------------------------------------------------
> > > > Dear all
> > > > Is it possible to set a field's default value in SQL Analyser?
> > > > When I created the table, I have not set the default values for the
> > fields
> > > > but I know I can change that in the Enterprise Manager. Can I do
that in
> > > the
> > > > SQL as well in the SQL Analyser.
> > > > Kevin
