⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 uninstall.sqldataprovider

📁 完整的商业模板和强大的后台管理功能
💻 SQLDATAPROVIDER
📖 第 1 页 / 共 4 页
字号:
/************************************************************/
/*****              SqlDataProvider                     *****/
/*****                                                  *****/
/*****                                                  *****/
/***** Note: To manually execute this script you must   *****/
/*****       perform a search and replace operation     *****/
/*****       for {databaseOwner} and {objectQualifier}  *****/
/*****                                                  *****/
/************************************************************/

/** Remove DotNetNuke Objects **/

ALTER TABLE {databaseOwner}[{objectQualifier}TabModuleSettings] DROP CONSTRAINT [FK_{objectQualifier}TabModuleSettings_{objectQualifier}TabModules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Roles] DROP CONSTRAINT [FK_{objectQualifier}Roles_{objectQualifier}Portals]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Tabs] DROP CONSTRAINT [FK_{objectQualifier}Tabs_{objectQualifier}Portals], CONSTRAINT [FK_{objectQualifier}Tabs_{objectQualifier}Tabs]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Profile] DROP CONSTRAINT [FK_{objectQualifier}Profile_{objectQualifier}Portals], CONSTRAINT [FK_{objectQualifier}Profile_{objectQualifier}Users]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}SearchItemWord] DROP CONSTRAINT [FK_{objectQualifier}SearchItemWord_{objectQualifier}SearchItem], CONSTRAINT [FK_{objectQualifier}SearchItemWord_{objectQualifier}SearchWord]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Modules] DROP CONSTRAINT [FK_{objectQualifier}Modules_{objectQualifier}ModuleDefinitions], CONSTRAINT [FK_{objectQualifier}Modules_{objectQualifier}Portals]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Folders] DROP CONSTRAINT [FK_{objectQualifier}Folders_{objectQualifier}Portals]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Affiliates] DROP CONSTRAINT [FK_{objectQualifier}Affiliates_{objectQualifier}Vendors]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UserDefinedRows] DROP CONSTRAINT [FK_{objectQualifier}UserDefinedRows_{objectQualifier}Modules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Classification] DROP CONSTRAINT [FK_{objectQualifier}Classification_{objectQualifier}Classification]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}ScheduleHistory] DROP CONSTRAINT [FK_{objectQualifier}ScheduleHistory_{objectQualifier}Schedule]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Vendors] DROP CONSTRAINT [FK_{objectQualifier}Vendor_{objectQualifier}Portals]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UserDefinedFields] DROP CONSTRAINT [FK_{objectQualifier}UserDefinedFields_{objectQualifier}Modules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}SearchItemWordPosition] DROP CONSTRAINT [FK_{objectQualifier}SearchItemWordPosition_{objectQualifier}SearchItemWord]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Announcements] DROP CONSTRAINT [FK_{objectQualifier}Announcements_{objectQualifier}Modules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Urls] DROP CONSTRAINT [FK_{objectQualifier}Urls_{objectQualifier}Portals]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}PortalAlias] DROP CONSTRAINT [FK_{objectQualifier}PortalAlias_{objectQualifier}Portals]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UrlLog] DROP CONSTRAINT [FK_{objectQualifier}UrlLog_{objectQualifier}UrlTracking]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UserRoles] DROP CONSTRAINT [FK_{objectQualifier}UserRoles_{objectQualifier}Roles], CONSTRAINT [FK_{objectQualifier}UserRoles_{objectQualifier}Users]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}ModuleSettings] DROP CONSTRAINT [FK_{objectQualifier}ModuleSettings_{objectQualifier}Modules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Skins] DROP CONSTRAINT [FK_{objectQualifier}Skins_{objectQualifier}Portals]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}SystemMessages] DROP CONSTRAINT [FK_{objectQualifier}SystemMessages_{objectQualifier}Portals]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}ModulePermission] DROP CONSTRAINT [FK_{objectQualifier}ModulePermission_{objectQualifier}Modules], CONSTRAINT [FK_{objectQualifier}ModulePermission_{objectQualifier}Permission]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}PortalDesktopModules] DROP CONSTRAINT [FK_{objectQualifier}PortalDesktopModules_{objectQualifier}DesktopModules], CONSTRAINT [FK_{objectQualifier}PortalDesktopModules_{objectQualifier}Portals]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Links] DROP CONSTRAINT [FK_{objectQualifier}Links_{objectQualifier}Modules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UserPortals] DROP CONSTRAINT [FK_{objectQualifier}UserPortals_{objectQualifier}Portals], CONSTRAINT [FK_{objectQualifier}UserPortals_{objectQualifier}Users]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}HtmlText] DROP CONSTRAINT [FK_{objectQualifier}HtmlText_{objectQualifier}Modules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UsersOnline] DROP CONSTRAINT [FK_{objectQualifier}UsersOnline_{objectQualifier}Portals], CONSTRAINT [FK_{objectQualifier}UsersOnline_{objectQualifier}Users]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}ModuleControls] DROP CONSTRAINT [FK_{objectQualifier}ModuleControls_{objectQualifier}ModuleDefinitions]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Discussion] DROP CONSTRAINT [FK_{objectQualifier}Discussion_{objectQualifier}Modules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}FolderPermission] DROP CONSTRAINT [FK_{objectQualifier}FolderPermission_{objectQualifier}Folders], CONSTRAINT [FK_{objectQualifier}FolderPermission_{objectQualifier}Permission]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}TabPermission] DROP CONSTRAINT [FK_{objectQualifier}TabPermission_{objectQualifier}Permission], CONSTRAINT [FK_{objectQualifier}TabPermission_{objectQualifier}Tabs]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}ModuleDefinitions] DROP CONSTRAINT [FK_{objectQualifier}ModuleDefinitions_{objectQualifier}DesktopModules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Files] DROP CONSTRAINT [FK_{objectQualifier}Files_{objectQualifier}Portals]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UserDefinedData] DROP CONSTRAINT [FK_{objectQualifier}UserDefinedData_{objectQualifier}UserDefinedFields], CONSTRAINT [FK_{objectQualifier}UserDefinedData_{objectQualifier}UserDefinedRows]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UrlTracking] DROP CONSTRAINT [FK_{objectQualifier}UrlTracking_{objectQualifier}Portals]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}TabModules] DROP CONSTRAINT [FK_{objectQualifier}TabModules_{objectQualifier}Modules], CONSTRAINT [FK_{objectQualifier}TabModules_{objectQualifier}Tabs]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}FAQs] DROP CONSTRAINT [FK_{objectQualifier}FAQs_{objectQualifier}Modules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Events] DROP CONSTRAINT [FK_{objectQualifier}Events_{objectQualifier}Modules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Documents] DROP CONSTRAINT [FK_{objectQualifier}Documents_{objectQualifier}Modules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}VendorClassification] DROP CONSTRAINT [FK_{objectQualifier}VendorClassification_{objectQualifier}Classification], CONSTRAINT [FK_{objectQualifier}VendorClassification_{objectQualifier}Vendors]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}SiteLog] DROP CONSTRAINT [FK_{objectQualifier}SiteLog_{objectQualifier}Portals]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}SearchItem] DROP CONSTRAINT [FK_{objectQualifier}SearchItem_{objectQualifier}Modules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Contacts] DROP CONSTRAINT [FK_{objectQualifier}Contacts_{objectQualifier}Modules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Banners] DROP CONSTRAINT [FK_{objectQualifier}Banner_{objectQualifier}Vendor]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}ScheduleItemSettings] DROP CONSTRAINT [FK_{objectQualifier}ScheduleItemSettings_{objectQualifier}Schedule]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}AnonymousUsers] DROP CONSTRAINT [FK_{objectQualifier}AnonymousUsers_{objectQualifier}Portals]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Urls] DROP CONSTRAINT [PK_{objectQualifier}Urls]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Urls] DROP CONSTRAINT [IX_{objectQualifier}Urls]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Roles] DROP CONSTRAINT [PK_{objectQualifier}Roles]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Roles] DROP CONSTRAINT [IX_{objectQualifier}RoleName]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Roles] DROP CONSTRAINT [DF_{objectQualifier}Roles_ServiceFee]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Roles] DROP CONSTRAINT [DF_{objectQualifier}Roles_IsPublic]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Roles] DROP CONSTRAINT [DF_{objectQualifier}Roles_AutoAssignment]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Tabs] DROP CONSTRAINT [PK_{objectQualifier}Tabs]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Tabs] DROP CONSTRAINT [DF_{objectQualifier}Tabs_TabOrder]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Tabs] DROP CONSTRAINT [DF_{objectQualifier}Tabs_IsVisible]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Tabs] DROP CONSTRAINT [DF_{objectQualifier}Tabs_Level]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Tabs] DROP CONSTRAINT [DF_{objectQualifier}Tabs_DisableLink]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Tabs] DROP CONSTRAINT [DF_{objectQualifier}Tabs_IsDeleted]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Users] DROP CONSTRAINT [PK_{objectQualifier}Users]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Users] DROP CONSTRAINT [IX_{objectQualifier}Users]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Users] DROP CONSTRAINT [DF_{objectQualifier}Users_IsSuperUser]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}SearchIndexer] DROP CONSTRAINT [PK_{objectQualifier}SearchIndexer]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Profile] DROP CONSTRAINT [PK_{objectQualifier}Profile]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}SearchItemWord] DROP CONSTRAINT [PK_{objectQualifier}SearchItemWords]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Modules] DROP CONSTRAINT [PK_{objectQualifier}Modules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Modules] DROP CONSTRAINT [DF_{objectQualifier}Modules_AllTabs]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Modules] DROP CONSTRAINT [DF_{objectQualifier}Modules_IsDeleted]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Folders] DROP CONSTRAINT [PK_{objectQualifier}Folders]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Affiliates] DROP CONSTRAINT [PK_{objectQualifier}Affiliates]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Schedule] DROP CONSTRAINT [PK_{objectQualifier}Schedule]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UserDefinedRows] DROP CONSTRAINT [PK_{objectQualifier}UserDefinedRows]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Permission] DROP CONSTRAINT [PK_{objectQualifier}Permission]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Classification] DROP CONSTRAINT [PK_{objectQualifier}VendorCategory]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Version] DROP CONSTRAINT [PK_{objectQualifier}Version]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Version] DROP CONSTRAINT [IX_{objectQualifier}Version]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}ScheduleHistory] DROP CONSTRAINT [PK_{objectQualifier}ScheduleHistory]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}TabModuleSettings] DROP CONSTRAINT [PK_{objectQualifier}TabModuleSettings]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}FAQs] DROP CONSTRAINT [PK_{objectQualifier}FAQs]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}SearchItemWordPosition] DROP CONSTRAINT [PK_{objectQualifier}SearchItemWordPosition]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Announcements] DROP CONSTRAINT [PK_{objectQualifier}Announcements]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Portals] DROP CONSTRAINT [PK_{objectQualifier}Portals]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Portals] DROP CONSTRAINT [DF_{objectQualifier}Portals_UserRegistration]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Portals] DROP CONSTRAINT [DF_{objectQualifier}Portals_BannerAdvertising]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Portals] DROP CONSTRAINT [DF_{objectQualifier}Portals_HostFee]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Portals] DROP CONSTRAINT [DF_{objectQualifier}Portals_HostSpace]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Portals] DROP CONSTRAINT [DF_{objectQualifier}Portals_GUId]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Portals] DROP CONSTRAINT [DF_{objectQualifier}Portals_DefaultLanguage]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Portals] DROP CONSTRAINT [DF_{objectQualifier}Portals_TimeZoneOffset]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Portals] DROP CONSTRAINT [DF_{objectQualifier}Portals_HomeDirectory]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}PortalAlias] DROP CONSTRAINT [PK_{objectQualifier}PortalAlias]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}PortalAlias] DROP CONSTRAINT [IX_{objectQualifier}PortalAlias]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UrlLog] DROP CONSTRAINT [PK_{objectQualifier}UrlLog]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UserRoles] DROP CONSTRAINT [PK_{objectQualifier}UserRoles]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}ModuleSettings] DROP CONSTRAINT [PK_{objectQualifier}ModuleSettings]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Skins] DROP CONSTRAINT [PK_{objectQualifier}Skins]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}SystemMessages] DROP CONSTRAINT [PK_{objectQualifier}SystemMessages]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}SystemMessages] DROP CONSTRAINT [IX_{objectQualifier}SystemMessages]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UsersOnline] DROP CONSTRAINT [PK_{objectQualifier}UsersOnline]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UsersOnline] DROP CONSTRAINT [DF_{objectQualifier}UsersOnline_CreationDate]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UsersOnline] DROP CONSTRAINT [DF_{objectQualifier}UsersOnline_LastActiveDate]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}ModulePermission] DROP CONSTRAINT [PK_{objectQualifier}ModulePermission]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}PortalDesktopModules] DROP CONSTRAINT [PK_{objectQualifier}PortalDesktopModules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}PortalDesktopModules] DROP CONSTRAINT [IX_{objectQualifier}PortalDesktopModules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Links] DROP CONSTRAINT [PK_{objectQualifier}Links]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UserPortals] DROP CONSTRAINT [PK_{objectQualifier}UserPortals]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UserPortals] DROP CONSTRAINT [DF_{objectQualifier}UserPortals_CreatedDate]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Lists] DROP CONSTRAINT [PK_{objectQualifier}Lists]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Lists] DROP CONSTRAINT [DF_{objectQualifier}Lists_ParentID]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Lists] DROP CONSTRAINT [DF_{objectQualifier}Lists_Level]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Lists] DROP CONSTRAINT [DF_{objectQualifier}Lists_SortOrder]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Lists] DROP CONSTRAINT [DF_{objectQualifier}Lists_DefinitionID]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}HtmlText] DROP CONSTRAINT [PK_{objectQualifier}HtmlText]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UserDefinedFields] DROP CONSTRAINT [PK_{objectQualifier}UserDefinedTable]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UserDefinedFields] DROP CONSTRAINT [DF_{objectQualifier}UserDefinedFields_FieldOrder]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}ModuleControls] DROP CONSTRAINT [PK_{objectQualifier}ModuleControls]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}ModuleControls] DROP CONSTRAINT [IX_{objectQualifier}ModuleControls]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Discussion] DROP CONSTRAINT [PK_{objectQualifier}Discussion]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}FolderPermission] DROP CONSTRAINT [PK_{objectQualifier}FolderPermission]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}TabPermission] DROP CONSTRAINT [PK_{objectQualifier}TabPermission]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}ModuleDefinitions] DROP CONSTRAINT [PK_{objectQualifier}ModuleDefinitions]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}ModuleDefinitions] DROP CONSTRAINT [IX_{objectQualifier}ModuleDefinitions]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}ModuleDefinitions] DROP CONSTRAINT [DF_{objectQualifier}ModuleDefinitions_DefaultCacheTime]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DesktopModules] DROP CONSTRAINT [PK_{objectQualifier}DesktopModules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DesktopModules] DROP CONSTRAINT [IX_{objectQualifier}DesktopModules_ModuleName]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}DesktopModules] DROP CONSTRAINT [DF_{objectQualifier}DesktopModules_SupportedFeatures]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Files] DROP CONSTRAINT [PK_{objectQualifier}File]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UserDefinedData] DROP CONSTRAINT [PK_{objectQualifier}UserDefinedData]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}HostSettings] DROP CONSTRAINT [PK_{objectQualifier}HostSettings]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}HostSettings] DROP CONSTRAINT [DF_{objectQualifier}HostSettings_Secure]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Vendors] DROP CONSTRAINT [PK_{objectQualifier}Vendor]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Vendors] DROP CONSTRAINT [IX_{objectQualifier}Vendors]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Vendors] DROP CONSTRAINT [DF_{objectQualifier}Vendors_ClickThroughs]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Vendors] DROP CONSTRAINT [DF_{objectQualifier}Vendors_Views]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}Vendors] DROP CONSTRAINT [DF_{objectQualifier}Vendors_Authorized]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}SearchCommonWords] DROP CONSTRAINT [PK_{objectQualifier}SearchCommonWords]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UrlTracking] DROP CONSTRAINT [PK_{objectQualifier}UrlTracking]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UrlTracking] DROP CONSTRAINT [IX_{objectQualifier}UrlTracking]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UrlTracking] DROP CONSTRAINT [DF_{objectQualifier}UrlTracking_TrackClicks]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}UrlTracking] DROP CONSTRAINT [DF_{objectQualifier}UrlTracking_NewWindow]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}TabModules] DROP CONSTRAINT [PK_{objectQualifier}TabModules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}TabModules] DROP CONSTRAINT [IX_{objectQualifier}TabModules]
GO
ALTER TABLE {databaseOwner}[{objectQualifier}TabModules] DROP CONSTRAINT [DF_{objectQualifier}TabModules_DisplayTitle]

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -