Object types

This article describes the supported object types in Exasol.

Supported object types

Exasol supports the object types function, schema, script, table, and view. To view a list of all objects that you have access to, use EXA_ALL_OBJECTS.

Function

An SQL function object is a set of SQL statements. Exasol supports built-in functions and user-defined functions (UDFs).

When you create a user-defined function (UDF) using CREATE FUNCTION, Exasol tracks the function with a function object ID. To see a list of user-defined functions you have access to in your schema and find a function’s object ID, see EXA_ALL_FUNCTIONS. The raw size of a function object is zero.

To learn more about UDFs, see User defined functions (UDFs). For information about built-in functions, see Built-in functions.

Script

A script object in Exasol is either a user-defined function (UDF) script, a scripting program, or an adapter script. It provides a way to write programs for your database using more than SQL. When you create a script using CREATE SCRIPT, Exasol tracks the script with a script object ID. To see a list of scripts you have access to in your schema and find a script’s object ID, see EXA_ALL_SCRIPTS. The raw size of a script object is zero.

To learn more about scripting in Exasol, see Scripting.

Table

An SQL table object is a two dimensional arrangement of data in rows and columns. When you create a table using CREATE TABLE, Exasol tracks the table with a table object ID. To see a list of tables you have access to in your schema and find a table’s object ID, see EXA_ALL_TABLES. The raw size of a table object is the size of the data contained within the table.

View

An SQL view object is a virtual table based on the result set of an SQL statement. When you create a view using CREATE VIEW, Exasol tracks the view with a view object ID. To see a list of views you have access to in your schema and find a view’s object ID, see EXA_ALL_VIEWS. The raw size of a view object is zero.

Object type raw sizes

The following table describes how the raw (uncompressed) size is determined for each object type.

Data type	Raw size in bytes
FUNCTION	The raw size of a function object is zero.
SCHEMA	The raw size of a schema object is the sum of the raw size of all the objects contained in the schema, such as tables.
SCRIPT	The raw size of a script object is zero.
TABLE	The raw size of a table object is the sum of the raw size of all the columns in the table.
VIEW	The raw size of a view object is zero.

To view the sizes of all objects, use the system table EXA_ALL_OBJECT_SIZES.