MySQL-->MSSQL

[m0119975]

hi

i have this in MySQL:

DROP TABLE IF EXISTS
nuke_words;
CREATE TABLE nuke_words (
word_id mediumint(8) unsigned NOT NULL auto_increment,
word char(100) NOT NULL,
replacement char(100) NOT NULL,
PRIMARY KEY (word_id)
);

but i can't convert it in MSSQL.
can anyone help me.

thx

[Lars_Berg]

if exists (select * from information_schema.tables where table_name='nuke_works' and schema_name = current_user )
drop table nuke_works

CREATE TABLE nuke_words (
word_id int NOT NULL identity,
word char(100) NOT NULL,
replacement char(100) NOT NULL,
PRIMARY KEY (word_id)
)

[mattr]

Why CHAR and not VARCHAR?