CODEWITHSUNDEEP
sqldatabasepostgresqlhana
Umid Umaraliev
Umid Umaraliev

Reputation: 59

How can I get constraint definition in SAP HANA?

I want to get a list of contraint definition in my schema. F.e. in postrge we can get from pg_get_constraintdef(c.oid, true) or in Oracle from DBMS_METADATA.get_ddl (object_type => 'INDEX',name => AI.INDEX_NAME, schema => AI.OWNER)

Is there any options to get it from SAP HANA?

Upvotes: 0

Views: 616

Answers (1)

Mathias Kemeter
Mathias Kemeter

Reputation: 1193

SAP HANA provides system views to retrieve this kind of information. In your case, you should have a look at system view CONSTRAINTS.

Upvotes: 2

Related Questions