Posts Tagged ‘alter table’
How to assign Default value of the Field in the table
Posted by: admin in MS SQL Server, SQL Server 2008 on June 16th, 2010
Use the ALTER TABLE command to assign the default value of the field.
Example:
ALTER TABLE [dbo].[tblHyperLink] ADD CONSTRAINT [DF__tblHyperL__LastU__021E29CA] DEFAULT (getdate()) FOR [LastUpdate]
GO