Help on MS SQL code# Database - 数据库
w*w
1 楼
What does following code do?
and what is corresponding My SQL code?
Thanks!
************************
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[FK_forum_bbsconfig]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [dbo].[forum] DROP CONSTRAINT FK_forum_bbsconfig
GO
........
........
........
CREATE TABLE [dbo].[calendar] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[title] [varchar] (255) COLLATE Chines
and what is corresponding My SQL code?
Thanks!
************************
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[FK_forum_bbsconfig]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [dbo].[forum] DROP CONSTRAINT FK_forum_bbsconfig
GO
........
........
........
CREATE TABLE [dbo].[calendar] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[title] [varchar] (255) COLLATE Chines