Functions, aggregates, and user types

Query system_schema functions, aggregates, and types tables to get information about user-defined functions, user-defined aggregates, and user-defined types.

Query system_schema aggregates, and types tables to get information about user-defined functions (UDFs), user-defined aggregates (UDAs), and user-defined types (UDTs). UDFs are not supported in Astra.

Tip: Use OpsCenter to view the CQL for defined UDF, UDA, and UDT in a keyspace.

Procedure

Show the schema settings for one user-defined type.

SELECT *
FROM system_schema.types
LIMIT 1;

@ Row 1
---------------+-------------------------------------------------
 keyspace_name | cycling
 type_name     | basic_info
 field_names   | ['birthday', 'nationality', 'height', 'weight']
 field_types   | ['timestamp', 'text', 'text', 'text']

(1 rows)