Constraint Information

Constraint Information

Postby samurae83 » Sun 23 Sep 2012 16:31

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
samurae83
 
Posts: 3
Joined: Wed 12 Sep 2012 10:32

Re: Constraint Information

Postby Pinturiccio » Tue 25 Sep 2012 13:04

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/docs/?MetaData.html
Pinturiccio
Devart Team
 
Posts: 1953
Joined: Wed 02 Nov 2011 09:44

Re: Constraint Information

Postby samurae83 » Wed 26 Sep 2012 00:45

Thank you
samurae83
 
Posts: 3
Joined: Wed 12 Sep 2012 10:32


Return to dotConnect for Oracle