CODEWITHSUNDEEP
sqlhana
Nicolas Loza
Nicolas Loza

Reputation: 53

How do I list user defined types in a HANA SQL Database?

I would like to be able to obtain a list of user defined types, similar to listing user defined procedures by calling

select * from SYS.PROCEDURES order by PROCEDURE_NAME;

Upvotes: 1

Views: 1537

Answers (1)

Lars Br.
Lars Br.

Reputation: 10388

As table types are the only user-definable types in SAP HANA you find those in the TABLES system table:

SELECT 
       * 
FROM 
     tables 
WHERE 
      is_user_defined_type ='TRUE';

cheers, Lars

Upvotes: 4

Related Questions