Constraint Information

[samurae83]

Hello.

I'm developing a sql executor that looks similar to SQLGATE.
I'm having a problem getting the constraint information of the table.

In the object panel of the SQLGATE, there's a Constraint Grid.
I've looked at the MetaData demo of the dotConnect for oracle samples but couldn't find the solution.

How can I get the data for the constraint info.

Thank you.

ps. this is a img. http://familyjokbo.net76.net/doku.php?id=img:img

[Pinturiccio]

You can get a constraint information by using the GetSchema method with ForeignKeys and PrimaryKeys collection name parameters of this method.
For more information about how to retrieve metedata please refer to http://www.devart.com/dotconnect/oracle ... aData.html

[samurae83]

Thank you