Constraint Information

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
samurae83
Posts: 3
Joined: Wed 12 Sep 2012 10:32

Constraint Information

Post by 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

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Constraint Information

Post by 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 ... aData.html

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

Re: Constraint Information

Post by samurae83 » Wed 26 Sep 2012 00:45

Thank you

Post Reply