Examples of renameSchemaObject()

Examples of org.h2.engine.Database.renameSchemaObject()

43
44
45
46
47
48
49
50
51
52
        }
        session.getUser().checkRight(oldTable, Right.ALL);
        if (oldTable.isTemporary()) {
            throw DbException.getUnsupportedException("TEMP TABLE");
        }
        db.renameSchemaObject(session, oldTable, newTableName);
        return 0;
    }

}
View Full Code Here

Examples of org.h2.engine.Database.renameSchemaObject()

214
215
216
217
218
219
220
221
222
223
224
            execute("DROP TABLE " + newTable.getName(), true);
            throw DbException.get(ErrorCode.VIEW_IS_INVALID_2, e, getSQL(), e.getMessage());
        }
        String tableName = table.getName();
        execute("DROP TABLE " + table.getSQL(), true);
        db.renameSchemaObject(session, newTable, tableName);
        for (DbObject child : newTable.getChildren()) {
            if (child instanceof Sequence) {
                continue;
            }
            String name = child.getName();
View Full Code Here

Examples of org.h2.engine.Database.renameSchemaObject()

235
236
237
238
239
240
241
242
243
244
245
                } else if (so instanceof Index) {
                    if (so.getSchema().findIndex(session, name) != null) {
                        name = so.getSchema().getUniqueIndexName(session, newTable, name);
                    }
                }
                db.renameSchemaObject(session, so, name);
            }
        }
        for (String view : views) {
            execute(view, true);
        }
View Full Code Here

Examples of org.h2.engine.Database.renameSchemaObject()

376
377
378
379
380
381
382
383
384
385
386
        List<String> viewSql = new ArrayList<String>();
        String sourceTableName = sourceTable.getName();
        String newTableName = newTable.getName();
        Database db = sourceTable.getDatabase();
        // save the real table under a temporary name
        db.renameSchemaObject(session, sourceTable, db.getTempTableName(session));
        try {
            // have our new table impersonate the target table
            db.renameSchemaObject(session, newTable, sourceTableName);
            checkViewsAreValid(sourceTable, viewSql);
        } finally {
View Full Code Here

Examples of org.h2.engine.Database.renameSchemaObject()

379
380
381
382
383
384
385
386
387
388
389
        Database db = sourceTable.getDatabase();
        // save the real table under a temporary name
        db.renameSchemaObject(session, sourceTable, db.getTempTableName(session));
        try {
            // have our new table impersonate the target table
            db.renameSchemaObject(session, newTable, sourceTableName);
            checkViewsAreValid(sourceTable, viewSql);
        } finally {
            // always put the source tables back with their proper names
            try {
                db.renameSchemaObject(session, newTable, newTableName);
View Full Code Here

Examples of org.h2.engine.Database.renameSchemaObject()

384
385
386
387
388
389
390
391
392
393
394
            db.renameSchemaObject(session, newTable, sourceTableName);
            checkViewsAreValid(sourceTable, viewSql);
        } finally {
            // always put the source tables back with their proper names
            try {
                db.renameSchemaObject(session, newTable, newTableName);
            } finally {
                db.renameSchemaObject(session, sourceTable, sourceTableName);
            }
        }
        return viewSql;
View Full Code Here

Examples of org.h2.engine.Database.renameSchemaObject()

386
387
388
389
390
391
392
393
394
395
396
        } finally {
            // always put the source tables back with their proper names
            try {
                db.renameSchemaObject(session, newTable, newTableName);
            } finally {
                db.renameSchemaObject(session, sourceTable, sourceTableName);
            }
        }
        return viewSql;
    }
View Full Code Here

Examples of org.h2.engine.Database.renameSchemaObject()

41
42
43
44
45
46
47
48
49
50
        Schema schema = oldIndex.getSchema();
        if (schema.findIndex(session, newIndexName) != null || newIndexName.equals(oldIndex.getName())) {
            throw DbException.get(ErrorCode.INDEX_ALREADY_EXISTS_1, newIndexName);
        }
        session.getUser().checkRight(oldIndex.getTable(), Right.ALL);
        db.renameSchemaObject(session, oldIndex, newIndexName);
        return 0;
    }

}
View Full Code Here

Examples of org.h2.engine.Database.renameSchemaObject()

89
90
91
92
93
94
95
96
97
98
99
            if (ifNotExists) {
                return 0;
            }

            if (orReplace && existingView.getTableType().equals(Table.VIEW)) {
                db.renameSchemaObject(session, existingView, db.getTempTableName(session));
                loadDependentViewSql(existingView, dependentViewSql);
            } else {
                throw DbException.get(ErrorCode.VIEW_ALREADY_EXISTS_1, viewName);
            }
        }
View Full Code Here

Examples of org.lealone.engine.Database.renameSchemaObject()

54
55
56
57
58
59
60
61
62
63
64
            throw DbException.get(ErrorCode.TABLE_OR_VIEW_ALREADY_EXISTS_1, newTableName);
        }
        if (oldTable.isTemporary()) {
            throw DbException.getUnsupportedException("temp table");
        }
        db.renameSchemaObject(session, oldTable, newTableName);
        return 0;
    }

    public int getType() {
        return CommandInterface.ALTER_TABLE_RENAME;
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.