if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求計算_物料編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[mrp物料需求計算] DROP CONSTRAINT mrp物料需求計算_物料編號_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求計算結果_物料編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[mrp物料需求計算結果] DROP CONSTRAINT mrp物料需求計算結果_物料編號_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求歷史_物料編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[mrp物料需求歷史] DROP CONSTRAINT mrp物料需求歷史_物料編號_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[物料清單_物料編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[物料清單] DROP CONSTRAINT 物料清單_物料編號_fk
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_分錄表_憑證表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[分錄表] DROP CONSTRAINT FK_分錄表_憑證表
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[本期匯總賬簿_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[本期匯總賬簿] DROP CONSTRAINT 本期匯總賬簿_科目代碼_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[本期明細賬簿_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[本期明細賬簿] DROP CONSTRAINT 本期明細賬簿_科目代碼_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[分錄表_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[分錄表] DROP CONSTRAINT 分錄表_科目代碼_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[圖書丟失_圖書編號_fk]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
ALTER TABLE [dbo].[圖書丟失] DROP CONSTRAINT 圖書丟失_圖書編號_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[FK_圖書罰款_圖書信息]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
ALTER TABLE [dbo].[圖書罰款] DROP CONSTRAINT FK_圖書罰款_圖書信息
GO
if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[圖書歸還_圖書編號_fk]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
ALTER TABLE [dbo].[圖書歸還] DROP CONSTRAINT 圖書歸還_圖書編號_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[圖書借閱_圖書編號_fk]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
ALTER TABLE [dbo].[圖書借閱] DROP CONSTRAINT 圖書借閱_圖書編號_fk
GO
if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[FK_圖書征訂_圖書信息]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
ALTER TABLE [dbo].[圖書征訂] DROP CONSTRAINT FK_圖書征訂_圖書信息
GO
if exists (select * from dbo.sysobjects where id = object_id(N\'[dbo].[圖書注銷_圖書編號_fk]\') and OBJECTPROPERTY(id, N\'IsForeignKey\') = 1)
ALTER TABLE [dbo].[圖書注銷] DROP CONSTRAINT 圖書注銷_圖書編號_fk
Abstract: Using a wafer-level package (WLP) can reduce the overall size and cost of your solution.However when using a WLP IC, the printed circuit board (PCB) layout can become more complex and, ifnot carefully planned, result in an unreliable design. This article presents some PCB designconsiderations and general recommendations for choosing a 0.4mm- or 0.5mm-pitch WLP for yourapplication.
CSL is a programming language with C syntax and comprehensive libraries. The compact scripting engine can also be embedded into your own applications as a powerful macro language. Windows Distribution utilities.
This book introduces embedded systems to C and C++ programmers. Topics include testing memory devices, writing and erasing Flash memory, verifying nonvolatile memory contents, controlling on-chip peripherals, device driver design and implementation, optimizing embedded code for size and speed, and making the most of C++ without a performance penalty. Pages : 336 Slots : 1
