table constraints

[Former Member]

how can we check the constraints applied on the columns of a table?

[arvind-kumar_avinash · Accepted solution]

Hybris does not provide any interface to view the constraints applied on the columns of a table. You need to check it in database itself. Given below are some examples:

In Oracle:

 SELECT * FROM user_cons_columns WHERE table_name = 'your-table-name';

In HSQLDB:

 SELECT * FROM information_schema.table_constraints WHERE table_name = 'YOUR-TABLE-NAME-IN-UPPER-CASE'

In MySQL:

 SHOW CREATE TABLE your-table-name;

[Former Member · Accepted solution]

how can we check the table structure in HAC. just like we have command "desc", do we have a similar thing in hybris also?

[arvind-kumar_avinash · Accepted solution]

Hi Rajat - You can check the table structure by using the command DESC table-name in the SQL Query tab as shown in the attached screenshot. Please note that DESC works for only Oracle and MySQL. For HSQLDB and MSSQL the equivalent command is:

 SELECT * FROM information_schema.columns WHERE table_name = 'your-table-name' 

[Former Member]

Hybris doesn't generate any constraints in a db schema apart from what is required from a DB engine for PK uniqueness.

[arvind-kumar_avinash]

Apart from PK, Hybris generates constraint for unique/index (Ref: https://help.hybris.com/1811/hcd/8ecae959b9bd46b8b426fa8dbde5cac4.html )