mysql语句变成mssql的

[steveyue]

DROP TABLE IF EXISTS bbslink;
CREATE TABLE bbslink (
id int(11) NOT NULL auto_increment,
boardname char(50) NOT NULL default '',
readme char(255) NOT NULL default '',
url char(150) NOT NULL default '',
KEY id(id)
) TYPE=MyISAM;
上面的是mysql的语句
怎么修改才能在查询分析器中通过

[子陌红尘]

IF EXISTS(select 1 from sysobjects where id = object_id('bbslink'))
DROP TABLE bbslink

CREATE TABLE bbslink (
id int identity(1,1) NOT NULL ,
boardname char(50) NOT NULL default '',
readme char(255) NOT NULL default '',
url char(150) NOT NULL default '',
CONSTRAINT Guid_PK PRIMARY KEY (id)
)