31 lines
1.4 KiB
Transact-SQL
31 lines
1.4 KiB
Transact-SQL
--作业票明细表索引
|
|
|
|
/****** Object: Index [NonClusteredIndex-20220527-102848] Script Date: 2022/5/27 10:29:15 ******/
|
|
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20220527-102848] ON [dbo].[License_LicenseItem]
|
|
(
|
|
[DataId] ASC,
|
|
[SortIndex] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
GO
|
|
|
|
--作业票审核表索引
|
|
/****** Object: Index [NonClusteredIndex-20220527-103009] Script Date: 2022/5/27 10:30:36 ******/
|
|
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20220527-103009] ON [dbo].[License_FlowOperate]
|
|
(
|
|
[DataId] ASC,
|
|
[SortIndex] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[CostGoods_GoodsManageFlowOperate] DROP CONSTRAINT [FK_CostGoods_GoodsManageFlowOperate_CostGoods_CostManage]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[CostGoods_GoodsManageFlowOperate] WITH CHECK ADD CONSTRAINT [FK_CostGoods_GoodsManageFlowOperate_CostGoods_GoodsManage] FOREIGN KEY([GoodsManageId])
|
|
REFERENCES [dbo].[CostGoods_GoodsManage] ([GoodsManageId])
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[CostGoods_GoodsManageFlowOperate] CHECK CONSTRAINT [FK_CostGoods_GoodsManageFlowOperate_CostGoods_GoodsManage]
|
|
GO
|
|
|
|
ALTER TABLE CostGoods_GoodsManage ALTER COLUMN States VARCHAR(10) NULL
|
|
GO |