Mercurial > hg > rc1

view SQL/mssql/2011121400.sql @ 18:e8f197ce1af3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
try to reuse same tab for linking back to message
author Charlie Root
date Mon, 15 Jan 2018 10:28:32 -0500
parents 1e000243b222
children
line wrap: on
line source

-- Updates from version 0.7

ALTER TABLE [dbo].[contacts] DROP CONSTRAINT [DF_contacts_email]
GO
ALTER TABLE [dbo].[contacts] ALTER COLUMN [email] [text] COLLATE Latin1_General_CI_AI NOT NULL
GO
ALTER TABLE [dbo].[contacts] ADD CONSTRAINT [DF_contacts_email] DEFAULT ('') FOR [email]
GO