How to get check constraint in database Schema text returned by Teiid

[nish18]

I have created a table in sqlserver database with check constraint on salary column.

CREATE TABLE check_test (emp_id int PRIMARY KEY,

                          emp_name varchar(45) NOT NULL,

                          salary int not null,

   CONSTRAINT chk_constraint CHECK (salary>0))

I refreshed the vdb file.

I called the teiid API to get database schema text.

I got the below database schema text.But it does not contain any check constraint.

CREATE FOREIGN TABLE check_test (

  emp_id integer NOT NULL OPTIONS (NAMEINSOURCE '"emp_id"', NATIVE_TYPE 'int'),

  emp_name string(45) NOT NULL OPTIONS (NAMEINSOURCE '"emp_name"', NATIVE_TYPE 'varchar'),

  salary integer NOT NULL OPTIONS (NAMEINSOURCE '"salary"', NATIVE_TYPE 'int'),

  CONSTRAINT PK__check_te__1299A861252F4FE2 PRIMARY KEY(emp_id)

) OPTIONS (NAMEINSOURCE "check_test"', UPDATABLE TRUE, CARDINALITY 0);

Can you please help me How do i get check constraint on database schema text returned by teiid getSchema() method.

[shawkins]

Source condition based constraints are currently not captured in the source metadata / ddl.  Do you need this represented in Teiid metadata?

[nish18]

Yes I need this in Teiid metadata, Can you please help  me How can I get this.

[rareddy]

The question how you intend to use this once it is in metadata?

You can always add additional OPTIONS clause entries to your VIEW/TABLE definition to any custom properties. You can manually edit the DDL for it, or add an extra metadata factory in the VDB issuing an ALTER TABLE statement. You can also extend the translator metadata importer to do the same, but I am not sure if JDBC DatabaseMetadata class shows this kind of information.

Typically these properties will only be useful if you are writing the custom translator. Once the property is defined, you get it back from RuntimeMetadata class.

Ramesh..