Обработка баз данных на Visual Basic®.NET

Прайс Кевин Т.

ALTER TABLE [dbo].[tblOrderltem] DROP CONSTRAINT FK_tblOrderItem_tblOrder

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tblCustomer_tblRegion] ')

and OBJECTPROPERTY(id, N'IsForeignKey') = 1

ALTER TABLE [dbo].[tblCustomer]

DROP CONSTRAINT FK_tblCustomer_tblRegion

GO

/****** object: Trigger dbo.trCustomerI Script Date: 10-Jul-02 12:41:09 PM ******/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[trCustomerI]')

and OBJECTPROPERTY(id,N'IsTrigger') =1)

drop trigger [dbo].[trCustomerI]

GO

/****** Object: Stored Procedure dbo.DeleteEmployee Script Date: 10-Jul-02 12:41:09 PM ******/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteEmployee]')

and OBJECTPPOPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[DeleteEmployee]

GO

/****** object: Stored Procedure Script Date: 10-Jul-02 12:41:09 PM ******/

if exists (select * from dbo.sysobjects dbo.sysobjects where id = object_id(N'[dbo].[GetCustomerFromID]')

and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[GetCustomerFromID]

GO

/****** Object: Stored Procedure dbo.insertEmployee Script Date: 10-Jul-02 12:41:09 PM ******/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertEmployee]')

and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[InsertEmployee]

GO

/****** Object: Stored Procedure dbo.InsertEmployeeOrg Script Date: 10-Jul-02 12:41:09 PM ******/

if exists (select * from dbo.sysobjects where id = object_id (N'[dbo].[InsertEmployeeOrg]')

and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[InsertEmployeeOrg]

GO

/****** Object: Stored Procedure dbo.LastNameLookup Script Date: 10-Jul-02 12:41:09 PM ******/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LastNameLookup]')

and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[LastNameLookup]

GO

/****** object: Stored Procedure Script Date: 10-Jul-02 12:41:09 PM ******/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SelectEmployees]')

and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[SelectEmployees]

GO

/****** object: Stored Procedure dbo Script Date: 10-Jul-02 12:41:09 PM ******/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UpdateEmployee]')

and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[UpdateEmployee]

GO

/****** object: Stored Procedure dbo.procEmployeesSorted Script Date: 10-Jul-02 12:41:09 PM ******/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[procEmployeesSorted]')

and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[procEmployeesSorted]

GO

/****** object: View dbo.EmployeeDepartment_view Script Date: 10-Jul-02 12:41:09 PM ******/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[EmployeeDepartment_view]')

and OBJECTPROPERTY(id, N'IsView') = 1)

drop view [dbo].[EmployeeDepartment_view]

GO

/****** Object: View dbo.qryEmployee_view Script Date: 10-Jul-02 12:41:09 PM ******/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[qryEmployee_view]')

and OBJECTPROPERTY(id,N'IsView') = 1)

drop view [dbo].[qryEmployee_view]

GO

/****** Object: Table [dbo].[tblCustomer] Script Date:10-Jul-0212:41:09 PM ******/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblCustomer]')

and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[tblCustomer]

GO

/****** Object: Table [dbo].[tblDepartment] Script Date: 10-Jul-02 12:41:09 PM ******/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblDepartment]')

and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[tblDepartment]

GO

/****** Object: Table [dbo].[tblEmployee] Script Date: 10-Jul-02 12:41:09 PM ******/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblEmployee]')

and OBJECTPROPERTY(id, N'IsUserTable') = 1)