if exists (SELECT * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求計(jì)算_物料編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[mrp物料需求計(jì)算] DROP CONSTRAINT mrp物料需求計(jì)算_物料編號_fk
GO
if exists (SELECT * from dbo.sysobjects where id = object_id(N'[dbo].[mrp物料需求計(jì)算結(jié)果_物料編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[mrp物料需求計(jì)算結(jié)果] DROP CONSTRAINT mrp物料需求計(jì)算結(jié)果_物料編號_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].[本期明細(xì)賬簿_科目代碼_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[本期明細(xì)賬簿] DROP CONSTRAINT 本期明細(xì)賬簿_科目代碼_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
基本的編輯工具(GENERAL EDITING FACILITIES)
對象放置(Object Placement)
ISIS支持多種類型的對象,每一類型對象的具體作用和功能將在下一章給出。雖然類型不同,但放置對象的基本步驟都是一樣的。
放置對象的步驟如下(To place an object:)
1.根據(jù)對象的類別在工具箱選擇相應(yīng)模式的圖標(biāo)(mode icon)。
2. SELECT the sub-mode icon for the specific type of object.
2、根據(jù)對象的具體類型選擇子模式圖標(biāo)(sub-mode icon)。
3、如果對象類型是元件、端點(diǎn)、管腳、圖形、符號或標(biāo)記,從選擇器里(SELECTor)選擇你想要的對象的名字。對于元件、端點(diǎn)、管腳和符號,可能首先需要從庫中調(diào)出。
4、如果對象是有方向的,將會在預(yù)覽窗口顯示出來,你可以通過點(diǎn)擊旋轉(zhuǎn)和鏡象圖標(biāo)來調(diào)整對象的朝向。
5、最后,指向編輯窗口并點(diǎn)擊鼠標(biāo)左鍵放置對象。對于不同的對象,確切的步驟可能略有不同,但你會發(fā)現(xiàn)和其它的圖形編輯軟件是類似的,而且很直觀。
選中對象(Tagging an Object)
用鼠標(biāo)指向?qū)ο蟛Ⅻc(diǎn)擊右鍵可以選中該對象。該操作選中對象并使其高亮顯示,然后可以進(jìn)行編輯。
This application note shows how a Xilinx CoolRunnerTM-II CPLD can be used as a simplelogical switch that can quickly and reliably SELECT between different MPEG video sources. Thesource code for the design is available on the Xilinx website, and is linked from the “VHDLCode” section. The code can be expanded by the user to perform additional operations usingthe remaining CPLD resources
基本的編輯工具(GENERAL EDITING FACILITIES)
對象放置(Object Placement)
ISIS支持多種類型的對象,每一類型對象的具體作用和功能將在下一章給出。雖然類型不同,但放置對象的基本步驟都是一樣的。
放置對象的步驟如下(To place an object:)
1.根據(jù)對象的類別在工具箱選擇相應(yīng)模式的圖標(biāo)(mode icon)。
2. SELECT the sub-mode icon for the specific type of object.
2、根據(jù)對象的具體類型選擇子模式圖標(biāo)(sub-mode icon)。
3、如果對象類型是元件、端點(diǎn)、管腳、圖形、符號或標(biāo)記,從選擇器里(SELECTor)選擇你想要的對象的名字。對于元件、端點(diǎn)、管腳和符號,可能首先需要從庫中調(diào)出。
4、如果對象是有方向的,將會在預(yù)覽窗口顯示出來,你可以通過點(diǎn)擊旋轉(zhuǎn)和鏡象圖標(biāo)來調(diào)整對象的朝向。
5、最后,指向編輯窗口并點(diǎn)擊鼠標(biāo)左鍵放置對象。對于不同的對象,確切的步驟可能略有不同,但你會發(fā)現(xiàn)和其它的圖形編輯軟件是類似的,而且很直觀。
選中對象(Tagging an Object)
用鼠標(biāo)指向?qū)ο蟛Ⅻc(diǎn)擊右鍵可以選中該對象。該操作選中對象并使其高亮顯示,然后可以進(jìn)行編輯。