01: /*
02: * Copyright 2004-2008 H2 Group. Licensed under the H2 License, Version 1.0
03: * (http://h2database.com/html/license.html).
04: * Initial Developer: H2 Group
05: */
06: package org.h2.command.ddl;
07:
08: import java.sql.SQLException;
09:
10: import org.h2.constant.ErrorCode;
11: import org.h2.engine.Database;
12: import org.h2.engine.Session;
13: import org.h2.message.Message;
14: import org.h2.schema.Schema;
15:
16: /**
17: * This class represents the statement
18: * DROP SCHEMA
19: */
20: public class DropSchema extends DefineCommand {
21:
22: private String schemaName;
23: private boolean ifExists;
24:
25: public DropSchema(Session session) {
26: super (session);
27: }
28:
29: public void setSchemaName(String name) {
30: this .schemaName = name;
31: }
32:
33: public int update() throws SQLException {
34: session.getUser().checkAdmin();
35: session.commit(true);
36: Database db = session.getDatabase();
37: Schema schema = db.findSchema(schemaName);
38: if (schema == null) {
39: if (!ifExists) {
40: throw Message.getSQLException(
41: ErrorCode.SCHEMA_NOT_FOUND_1, schemaName);
42: }
43: } else {
44: if (!schema.canDrop()) {
45: throw Message.getSQLException(
46: ErrorCode.SCHEMA_CAN_NOT_BE_DROPPED_1,
47: schemaName);
48: }
49: db.removeDatabaseObject(session, schema);
50: }
51: return 0;
52: }
53:
54: public void setIfExists(boolean ifExists) {
55: this.ifExists = ifExists;
56: }
57:
58: }
|