Auto Generated Field

Is there any way to add an auto-generated ID field? I have not seen a RDBMS that does have an identity field that can be auto generated. If there isn't a way to do it in creator, could someone please tell me how I can auto populate the id.