Autogenerated values..

[raseena nm]

HI all,
Is there any way to know that , which all fields in a table holds auto generated values?
for eg:
SQL> desc test_AUTO;
Name Null? Type
--------------------- -------- --------------------
VV NUMBER(10)

actually while inserting value to VV imj using sequence.
Here i know that VV is autogenerated.
But if i know only the structure of a table.How can i know that how many fields in that table holds autogenerated values??
thanx.

[Dan Drillich]

Please try:

select * from user_objects
where object_type = 'SYNONYM'

It will show you all the synonyms in your schema.
Regards,
Dan

[SJ Adnams]

Dan, I think Raseena was looking for default column values that are autonumbered.
You can't do this in oracle (unless you use triggers) but I think other databases support it...
(yes I know this was equally unhelpful)

[raseena nm]

I think Simon understands my question.
thanx to all of you.