View Oracle constraints?

View: New views

2 Messages — Rating Filter: Alert me

View Oracle constraints?

by Dan Jatnieks-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.

I am using Squirrel 2.6.9 and when connected to an Oracle database cannot seem to find a way to view a table’s column constraints (other than the PK and FK). I am particularly interested in seeing UK constraints, but other column level constraints would be good too. Is there a way to do it? I think I have the Oracle plugin – Plugins->Summary does lists it as being loaded.

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: View Oracle constraints?

by manningr :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

For unique keys, have a look at the "Indexes" tab when you select
a table in the Objects tab.

Rob

On Wed, Oct 21, 2009 at 7:55 PM, Dan Jatnieks
<djatnieks@...> wrote:

> I am using Squirrel 2.6.9 and when connected to an Oracle database cannot
> seem to find a way to view a table’s column constraints (other than the PK
> and FK). I am particularly interested in seeing UK constraints, but other
> column level constraints would be good too. Is there a way to do it? I think
> I have the Oracle plugin – Plugins->Summary does lists it as being loaded.
>
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>