MsSQL INDEXing a column

[Coyote6]

Can someone please tell me the MsSQL equivalent of this MySQL statement:

CREATE TABLE `test` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(5),
`foreign_key` INT UNSIGNED NOT NULL DEFAULT '0',
UNIQUE INDEX (`name`),
INDEX (`foreign_key`)
);


I'm having a problem with the INDEX part. Here is what I have:

CREATE TABLE test (
id INT NOT NULL IDENTITY PRIMARY KEY,
name VARCHAR(5),
foreign_key INT NOT NULL DEFAULT '0',
UNIQUE (name),
INDEX (foreign_key)
);


Thanks.