DbObject

A database object such as a table, an index, or a user.

Methods
void checkRename()
Check if renaming is allowed.
void checkRename()
Check if renaming is allowed. Does nothing when allowed.
ArrayList getChildren()
Get the list of dependent children (for tables, this includes indexes and so on).
ArrayList getChildren()
Get the list of dependent children (for tables, this includes indexes and so on).
Returns:
the list of children
String getComment()
Get the current comment of this object.
String getComment()
Get the current comment of this object.
Returns:
the comment, or null if not set
String getCreateSQL()
Construct the original CREATE ...
String getCreateSQL()
Construct the original CREATE ... SQL statement for this object.
Returns:
the SQL statement
String getCreateSQLForCopy(Table table, String quotedName)
Build a SQL statement to re-create the object, or to create a copy of the object with a different name or referencing a different table
String getCreateSQLForCopy(Table table, String quotedName)
Build a SQL statement to re-create the object, or to create a copy of the object with a different name or referencing a different table
Parameters:
table - the new table
quotedName - the quoted name
Returns:
the SQL statement
Database getDatabase()
Get the database.
Database getDatabase()
Get the database.
Returns:
the database
String getDropSQL()
Construct a DROP ...
String getDropSQL()
Construct a DROP ... SQL statement for this object.
Returns:
the SQL statement
int getId()
Get the unique object id.
int getId()
Get the unique object id.
Returns:
the object id
String getName()
Get the name.
String getName()
Get the name.
Returns:
the name
String getSQL()
Get the SQL name of this object (may be quoted).
String getSQL()
Get the SQL name of this object (may be quoted).
Returns:
the SQL name
int getType()
Get the object type.
int getType()
Get the object type.
Returns:
the object type
boolean isTemporary()
Check if this object is temporary (for example, a temporary table).
boolean isTemporary()
Check if this object is temporary (for example, a temporary table).
Returns:
true if is temporary
void removeChildrenAndResources(Session session)
Delete all dependent children objects and resources of this object.
void removeChildrenAndResources(Session session)
Delete all dependent children objects and resources of this object.
Parameters:
session - the session
void rename(String newName)
Rename the object.
void rename(String newName)
Rename the object.
Parameters:
newName - the new name
void setComment(String comment)
Change the comment of this object.
void setComment(String comment)
Change the comment of this object.
Parameters:
comment - the new comment, or null for no comment
void setTemporary(boolean temporary)
Tell this object that it is temporary or not.
void setTemporary(boolean temporary)
Tell this object that it is temporary or not.
Parameters:
temporary - the new value

Fields
static int AGGREGATE = 14
static int COMMENT = 13
static int CONSTANT = 11
static int CONSTRAINT = 5
static int FUNCTION_ALIAS = 9
static int INDEX = 1
static int RIGHT = 8
static int ROLE = 7
static int SCHEMA = 10
static int SEQUENCE = 3
static int SETTING = 6
static int TABLE_OR_VIEW = 0
static int TRIGGER = 4
static int USER = 2
static int USER_DATATYPE = 12

TABLE_OR_VIEW = 0

The object is of the type table or view.

INDEX = 1

This object is an index.

SCHEMA = 10

This object is a schema.

CONSTANT = 11

This object is a constant.

USER_DATATYPE = 12

This object is a user data type (domain).

COMMENT = 13

This object is a comment.

AGGREGATE = 14

This object is a user-defined aggregate function.

USER = 2

This object is a user.

SEQUENCE = 3

This object is a sequence.

TRIGGER = 4

This object is a trigger.

CONSTRAINT = 5

This object is a constraint (check constraint, unique constraint, or referential constraint).

SETTING = 6

This object is a setting.

ROLE = 7

This object is a role.

RIGHT = 8

This object is a right.

FUNCTION_ALIAS = 9

This object is an alias for a Java function.