C# 各种数据库操作例子

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InetSrvLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[InetSrvLog] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RTblClassDefs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RTblClassDefs] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RTblDatabaseVersion]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RTblDatabaseVersion] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RTblIfaceDefs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RTblIfaceDefs] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RTblIfaceMem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RTblIfaceMem] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RTblNamedObj]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RTblNamedObj] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RTblPropDefs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RTblPropDefs] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RTblProps]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RTblProps] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RTblRelColDefs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RTblRelColDefs] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RTblRelshipProps]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RTblRelshipProps] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RTblRelships]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RTblRelships] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RTblRoot]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RTblRoot] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RTblSites]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RTblSites] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RTblSumInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RTblSumInfo] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RTblTypeLibs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RTblTypeLibs] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RTblVersions]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RTblVersions] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[RTblWorkspaceItems]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[RTblWorkspaceItems] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UmlAssociationRole]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[UmlAssociationRole] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UmlAttribute]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[UmlAttribute] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UmlElement]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[UmlElement] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UmlGeneralizableElement]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[UmlGeneralizableElement] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UmlMember]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[UmlMember] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UmlNote]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[UmlNote] GO if exists (select * from dbo.sysobjects where id = object_i�