Skip to main content

db_object_sql

1. DB_OBJECT_SQL Function​

The DB_OBJECT_SQL function in H2 database is used to retrieve the SQL statement that created a specific database object.

2. Syntax​

The syntax for the DB_OBJECT_SQL function in H2 database is as follows:

DB_OBJECT_SQL(type, name)

Arguments​

  • type: The type of the database object. It should be a string value representing the object type, such as 'TABLE', 'VIEW', 'INDEX', 'SEQUENCE', etc.
  • name: The name of the database object. It should be a string value representing the object name.

Return​

  • The DB_OBJECT_SQL function returns the SQL statement that created the specified database object.

3. Notes​

  • The DB_OBJECT_SQL function in H2 database can be used to retrieve the original SQL statement used to create a table, view, index, sequence, or other database objects.
  • If the specified object does not exist or if the user does not have sufficient privileges to access the object, the DB_OBJECT_SQL function will return NULL.
  • The returned SQL statement may contain additional information or options specific to H2 database, so it may differ from the statement used in other databases.

4. Examples​

Here are a few examples demonstrating the usage of the DB_OBJECT_SQL function in H2 database:

Example 1 - Retrieving the SQL statement for a table:​

SELECT DB_OBJECT_SQL('TABLE', 'my_table') AS create_statement;

Output:

create_statement
----------------------------------
CREATE TABLE my_table (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  age INT
)

Example 2 - Retrieving the SQL statement for a view:​

SELECT DB_OBJECT_SQL('VIEW', 'my_view') AS create_statement;

Output:

create_statement
----------------------------------------------------------
CREATE VIEW my_view AS SELECT id, name FROM my_table WHERE age > 18

Example 3 - Retrieving the SQL statement for an index:​

SELECT DB_OBJECT_SQL('INDEX', 'my_index') AS create_statement;

Output:

create_statement
--------------------------------------------------
CREATE INDEX my_index ON my_table (name ASC, age DESC)

There are no specific related functions for the DB_OBJECT_SQL function in H2 database.