database , table, field , query naming/coding conventions ??
Posted: Thu Jan 18, 2007 9:45 pm
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
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