samedi 23 juillet 2016

Incremental table index

In all SQL tables I'm using incremental index with name id. I'm not sure I'm right since I have heard that some SQL servers increment it's records as default. I'm right? How to get these default increment fields values then in different SQL servers?

Another question in case I use my own id - what data type I should use for this field? Currently I'm using int type.

Aucun commentaire:

Enregistrer un commentaire