It's on SQL Server 2000 with latest JDBC driver. On 4/4/06, Jun Li <[EMAIL PROTECTED]> wrote: > > I found that foreign-keys (reference to a same table) doesn't generated > in a particular order. > > For example, schema 1: > > <table name="EmployeeTypeCodingFieldMap"> > <column name="EmployeeTypeCodingFieldMapID" primaryKey="true" > required="true" type="NUMERIC" size="8" autoIncrement="true"/> > <column name="EmployeeTypeFK" primaryKey="false" required="true" > type="NUMERIC" size="8" autoIncrement="false"/> > <column name="CodingFieldFK" primaryKey="false" required="true" > type="NUMERIC" size="8" autoIncrement="false"/> > <column name="IsCompulsory" primaryKey="false" required="true" > type="CHAR" size="1" default="Y" autoIncrement="false"/> > <column name="SortOrder" primaryKey="false" required="true" > type="NUMERIC" size="8" autoIncrement="false"/> > <column name="ImpliedByCodingFieldFK" primaryKey="false" > required="false" type="NUMERIC" size="8" autoIncrement="false"/> > <foreign-key foreignTable="CodingField" > name="FK_EmpTypeCodngFldMap_CodngFld"> > <reference local="CodingFieldFK" foreign="CodingFieldID"/> > </foreign-key> > <foreign-key foreignTable="CodingField" > name="FK_EmpTypeCFM_ImpByCodingField"> > <reference local="ImpliedByCodingFieldFK" > foreign="CodingFieldID"/> > </foreign-key> > <foreign-key foreignTable="EmployeeType" > name="FK_EmpTypeCodngFldMap_EmpType"> > <reference local="EmployeeTypeFK" foreign="EmployeeTypeID"/> > </foreign-key> > <unique name="PK_EmployeeTypeGLCodeTypeMap"> > <unique-column name="EmployeeTypeCodingFieldMapID"/> > </unique> > <index name="IX_EmpTpCodngFldMp_ImpCodngFld"> > <index-column name="ImpliedByCodingFieldFK"/> > </index> > <index name="IX_EmpTypeCodingFldMap_EmpType"> > <index-column name="EmployeeTypeFK"/> > </index> > <index name="IX_EmpTypeCodngFldMap_CodngFld"> > <index-column name="CodingFieldFK"/> > </index> > </table> > > schema 2: > > <table name="EmployeeTypeCodingFieldMap"> > <column name="EmployeeTypeCodingFieldMapID" primaryKey="true" > required="true" type="NUMERIC" size="8" autoIncrement="true"/> > <column name="EmployeeTypeFK" primaryKey="false" required="true" > type="NUMERIC" size="8" autoIncrement="false"/> > <column name="CodingFieldFK" primaryKey="false" required="true" > type="NUMERIC" size="8" autoIncrement="false"/> > <column name="IsCompulsory" primaryKey="false" required="true" > type="CHAR" size="1" default="Y" autoIncrement="false"/> > <column name="SortOrder" primaryKey="false" required="true" > type="NUMERIC" size="8" autoIncrement="false"/> > <column name="ImpliedByCodingFieldFK" primaryKey="false" > required="false" type="NUMERIC" size="8" autoIncrement="false"/> > <foreign-key foreignTable="CodingField" > name="FK_EmpTypeCFM_ImpByCodingField"> > <reference local="ImpliedByCodingFieldFK" > foreign="CodingFieldID"/> > </foreign-key> > <foreign-key foreignTable="CodingField" > name="FK_EmpTypeCodngFldMap_CodngFld"> > <reference local="CodingFieldFK" foreign="CodingFieldID"/> > </foreign-key> > <foreign-key foreignTable="EmployeeType" > name="FK_EmpTypeCodngFldMap_EmpType"> > <reference local="EmployeeTypeFK" foreign="EmployeeTypeID"/> > </foreign-key> > <unique name="PK_EmployeeTypeGLCodeTypeMap"> > <unique-column name="EmployeeTypeCodingFieldMapID"/> > </unique> > <index name="IX_EmpTpCodngFldMp_ImpCodngFld"> > <index-column name="ImpliedByCodingFieldFK"/> > </index> > <index name="IX_EmpTypeCodingFldMap_EmpType"> > <index-column name="EmployeeTypeFK"/> > </index> > <index name="IX_EmpTypeCodngFldMap_CodngFld"> > <index-column name="CodingFieldFK"/> > </index> > </table> > > schema 1, 2 generated from different DB but the DBs have exactly the same > structure. > > And this issue happened on several tables. > > Any idea? > > > > -------------- > Cheers, > Jun >
-- -------------- Cheers, Jun
