RE: Help with PRIMARY KEY

James <[email protected]> Wed, 23 Feb 2005 09:31:38 -0800 (PST)

Newsgroups	gmane.comp.db.mckoi
Message-ID	<[email protected]>

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]