The GET_DDL function fetches the metadata of an object and returns the data in DDL.
The GET_xxx functions return the metadata of objects with a single call. The current OceanBase Database version supports only GET_DDL.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
FUNCTION GET_DDL (
object_type VARCHAR,
name VARCHAR,
ob_schema VARCHAR DEFAULT NULL,
version VARCHAR DEFAULT 'COMPATIBLE',
model VARCHAR DEFAULT 'ORACLE',
transform VARCHAR DEFAULT 'DDL')
RETURN CLOB;
Parameters
| Parameter | Description |
|---|---|
| object_type | The type of the object to retrieve. The attributes of the object type must be a named object. |
| name | The name of the object. |
| ob_schema | The schema that contains the object. The default value of this parameter is the schema of the caller. |
| version | The version of the metadata. |
| model | The object model of the metadata. |
| transform | Uses XSL-T to convert the output. |