Functions, aggregates, and user types
Querying system.schema_* tables directly to get information about user-defined functions, aggregates, and user types.
Currently, the system tables are the only method of displaying information about user-defined functions, aggregates, and user types.
Procedure
-
Show all user-defined functions in the
system.schema_functions table.
cqlsh> SELECT * FROM system.schema_functions;
-
Show all user-defined aggregates in the
system.schema_aggregates table.
cqlsh> SELECT * FROM system.schema_aggregates;
-
Show all user-defined types in the system.schema_usertypes
table.
cqlsh> SELECT * FROM system.schema_usertypes;