Re: Help with PRIMARY KEY

Thank you very much Mr. James.

Your help was very important to solve my problem. :-)

Caetano (from Brazil)


On Wed, 23 Feb 2005 09:31:38 -0800 (PST), James <[email protected]> wrote:
> Following will list the primary key:
> 
> select "info.schema" "schema"
>      , "info.table" "table"
>      , "pc.column" pk_columns
>   from SYS_INFO.sUSRPrimaryColumns pc
>      , SYS_INFO.sUSRPKeyInfo info
>  where "info.table" like '%'
>    and info.id = pc.pk_id;
> 
> For anything else, you can find the appropriate table
> via SYS_INFO.sUSRTableInfo table;
> 
> Jim
> 
> ---------------------------------------------------------------
> Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> To unsubscribe, send a message to [email protected]
> 
>


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]