?? dbo.community_custom_redirect.sql
字號:
IF EXISTS (SELECT * FROM sysobjects WHERE type = 'U' AND name = 'Community_Custom_Redirect')
BEGIN
DROP Table dbo.Community_Custom_Redirect
END
GO
CREATE TABLE dbo.Community_Custom_Redirect
(
[redirect_communityID] [int] NOT NULL ,
[redirect_SourceURL] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[redirect_DestinationURL] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[redirect_isSectionRedirect] [bit] NOT NULL
)
GO
ALTER TABLE [dbo].[Community_Custom_Redirect] WITH NOCHECK ADD
CONSTRAINT [PK_Community_Custom_Redirect] PRIMARY KEY CLUSTERED
(
[redirect_communityID],
[redirect_SourceURL]
)
GO
ALTER TABLE [dbo].[Community_Custom_Redirect] ADD
CONSTRAINT [FK_Community_Custom_Redirect_Community_Communities] FOREIGN KEY
(
[redirect_communityID]
) REFERENCES [dbo].[Community_Communities] (
[community_id]
) ON DELETE CASCADE
GO
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -