Identity

[Nagham]

hi there,I'm working on a software that have to be a DBChecker I need to know by a query :
1:if the Key is Identity or not
2:if there's an IndexesKey
3:if there's a triggers
4:if there's a Procedures

Any help plz

[davide++]

Hi all.

According to your database (which is unknown for us), you should see the system tables (or dictionary, as they're called in Oracle); they contain the metadata that describe the objects of database.
Notice that if you define a primary key on a field usually there'll be an index on this field.