i am eager to know the convention or standards used for naming database,table,fields.
Can anybody suggest here. i am always in dilemma in using for example
1> users or user , which table name is preferred
2>id or tableName_id , which should be preferred
etc etc.
Also it would be helpful to many if coding standards for sql query is also mentioned.
waiting for the results
hope for the best
Thanks
database , table, field , query naming/coding conventions ??
Moderator: General Moderators
I am with feyd, I always use that conventions because you can easily query database without viewing it.feyd wrote:I typically use <applicationName>_<descriptiveTableName> for table names. "users" versus "user" doesn't really matter to me.
As for field identifiers, the same basic principle is used: <tableName>_<descriptiveFieldName>.