Beispiel #1
0
        public static Table NewLookupTable(Database database, QNameManager.QName tableName, int tableType, QNameManager.QName colName, SqlType colType)
        {
            Table        table;
            ColumnSchema column   = new ColumnSchema(colName, colType, false, true, null);
            TableDerived derived1 = new TableDerived(database, tableName, tableType);

            derived1.AddColumn(column);
            TableDerived derived2 = table = derived1;

            QNameManager.QName indexName = derived2.GetName();
            int[] columns = new int[1];
            table.CreatePrimaryKeyConstraint(indexName, columns, true);
            return(derived2);
        }
Beispiel #2
0
        public static Table NewLookupTable(Database database)
        {
            Table table;

            QNameManager.QName subqueryTableName = database.NameManager.GetSubqueryTableName();
            ColumnSchema       column            = new ColumnSchema(QNameManager.GetAutoColumnName(0), SqlType.SqlInteger, false, true, null);
            TableDerived       derived1          = new TableDerived(database, subqueryTableName, 2, null, null);

            derived1.AddColumn(column);
            TableDerived derived2 = table = derived1;

            QNameManager.QName name = derived2.GetName();
            int[] columns           = new int[1];
            table.CreatePrimaryKeyConstraint(name, columns, true);
            return(derived2);
        }