constraints tag is missing referencedTableSchemaName
Description
Environment
N/A
Activity
Show:
Nathan Voxland March 14, 2016 at 3:57 PM
Fixed
Fixed
Details
Details
Reporter
Kirk Rasmussen
Kirk RasmussenComponents
Fix versions
Affects versions
Priority
Created July 24, 2014 at 7:55 PM
Updated March 14, 2016 at 3:57 PM
Resolved March 14, 2016 at 3:57 PM
The constraints tag is missing the ability to specify a schema name.
referencedTableSchemaName doesn't exist as attribute:
<column name="TemplateOwnerId" type="INT">
<constraints foreignKeyName="FK_EvaluationTemplate_Person"
referencedTableName="Person"
referencedColumnNames="PersonId"
nullable="false"/>
</column>
As a workaround its possible to a foreign key after the fact, i.e.
<addForeignKeyConstraint baseColumnNames="PersonId"
baseTableName="Person"
baseTableSchemaName="gemini"
constraintName="FK_EvaluationTemplate_Person"
referencedColumnNames="PersonId"
referencedTableName="Person"
referencedTableSchemaName="dbo"/>