转换数据库语法问题
CREATE TABLE analysismodel (
modelId BIGINT NOT NULL IDENTITY,
com_id BIGINT DEFAULT NULL,
modelName VARCHAR(200) DEFAULT NULL,
modelNotes VARCHAR(500) DEFAULT NULL,

PRIMARY KEY (modelId),
INDEX FK_analysismodel_company_com_id (com_id),
CONSTRAINT FK_analysismodel_company_com_id FOREIGN KEY (com_id)
REFERENCES company(com_id) ON DELETE RESTRICT ON UPDATE RESTRICT
)
上面是My sql创建的语法、我怎么把它改成sql server创建的语法？主要是外键部分

[解决办法]

SQL code

CREATE TABLE analysismodel (  modelId BIGINT IDENTITY(1,1) primary key ,  com_id BIGINT REFERENCES company(com_id) ON DELETE CASCADE on update CASCADE ,  modelName VARCHAR(200) DEFAULT('') ,  modelNotes VARCHAR(500) DEFAULT(''))