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
Constraint Information
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Constraint Information
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
For more information about how to retrieve metedata please refer to http://www.devart.com/dotconnect/oracle ... aData.html