search

OHDSI / CommonDataModel

Definition and DDLs for the OMOP Common Data Model (CDM)
https://ohdsi.github.io/CommonDataModel
877 stars 448 forks source link

idx_concept_id_varchar not valid in SQL Server #347

Closed cg3y closed 3 years ago

cg3y commented 4 years ago

The statement:

CREATE INDEX idx_concept_id_varchar ON concept (CAST(concept_id AS VARCHAR));

is not valid SQL Server syntax. This breaks the SQL Server "OMOP CDM sql server pk indexes.txt" script.

clairblacketer commented 3 years ago

Thanks - this has been fixed in the repository we use to develop the DDLS