| http://www.w3.org/ns/prov#value | - The T-SQL for doing that is:ALTER TABLE [dbo].[YourTable] ADD CONSTRAINT [DF_YourTable_strWhoEdited] DEFAULT (suser_sname()) FOR [strWhoEdited]However we usually use the table designer SSMS to set such things as default values, Null or Not Null, etc.WendellColorado, USA
|
