如何编写语句修改Check约束？

2009-03-31 09:05:24 283 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

【ES】--Elasticsearch的分词器深度研究分词器是ik_max_word，会将“龙马家书”拆分为“龙马”、“马家”、“家书”。然后filter配置的是edge_ngram_filter，在上面拆分的token词组基础上，按照edge_ngram_filter规则进一步拆分。从结果看：分词器是keyword，filter支持edge_ngram_filter，字符过滤器支持tsconvert【简繁体】。分词器是keyword，表明是不进行分词，但filtet中edge_ngram_filter是按照布长方式拆分token，所以得到如此结果。阅读详情

CREATE TABLE [sale_Day_Details_200901]
(
[CompanyCD] [smallint] NOT NULL ,
[BrancheCD] [smallint] NOT NULL ,
[BusinessDate] [smalldatetime] NOT NULL ,
[CostPrice] [money] NULL ,
[SaleQty] [money] NULL ,
[SaleSum] [money] NULL ,
[SaleTaxoutSum] [money] NULL ,
[PosDiscountQty] [money] NULL ,
[PosDiscountSum] [money] NULL ,
[SysLossSum] [money] NULL ,
[CustomerAmount] [int] NULL ,
[YearMonth] [int] NOT NULL ,
[YearWeek] [int] NULL ,
[UpdateDateTime] [datetime] NULL ,
CONSTRAINT [PK_sale_Day_Details_200901] PRIMARY KEY CLUSTERED
(
[CompanyCD],
[BrancheCD],
[BusinessDate],
[YearMonth]
) WITH FILLFACTOR = 90 ON [PRIMARY] ,
CONSTRAINT [CK_sale_Day_Details_200901_YearMonth] CHECK ([YearMonth] = 200901)
) ON [PRIMARY]
GO

这是表结构，数据库中有这样的表很多个，我想通过编写语句，来更新上面的CHECK 约束，请高手指点，很急...

...全文