I would like to know some conventions regarding nomenclature.
For example, I see fields (columns) composed of multiple words separated by underscore characters, and the words beyond the first are lowercase, like so:
But is it advisable NOT to use other conventions, like camel case, or all initial capitals on multi-word field names?
And what about the naming and use of character case for other SQL structures: database and table, especially composed of multiple words.
Another question: what is the permitted character set for all names of databases, tables, fields, etc.? Are "foreign characters" permitted such as ö, ü, ç, ş?