Iam working in vb as front end and sqlserver as backend.I would like to know the naming standards for tables
and fields in a table.
i would also like to know if it is independent of the backend we use.
Printable View
Iam working in vb as front end and sqlserver as backend.I would like to know the naming standards for tables
and fields in a table.
i would also like to know if it is independent of the backend we use.
There are no fixed standards just ensure that you find a convention and stick to it.
Generally good practice to make the Table/Field names meaningful (i.e. FirstName not Field1)
I use tTableName to make it clear when I am using a table, I also often use things like q001_FirstQuery, q002_SecondQuery to make logical groupings of similar entities.
Don't use spaces, it causes more truble than it is worth and finally....
No it is not back end independent because legal names in some databases will cause problems in others. Generally if you stick to AlphanumericNames without spaces, you'll be OK.
Cheers,
Paul.