uninstall.sql

来自「FAQ-Modified for Rainbow」· SQL 代码 · 共 27 行

/* Uninstall script, FAQs module, Jakob Hansen, 25 april 2003 */

/* No we do not delete the table!
if exists (select * from dbo.sysobjects where id = object_id(N'[rb_FAQs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [rb_FAQs] */
--GO

if exists (select * from dbo.sysobjects where id = object_id(N'[rb_AddFAQ]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [rb_AddFAQ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[rb_DeleteFAQ]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [rb_DeleteFAQ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[rb_GetFAQ]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [rb_GetFAQ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[rb_GetSingleFAQ]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [rb_GetSingleFAQ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[rb_UpdateFAQ]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [rb_UpdateFAQ]
GO