0

I browsed ISO/IEC 9075:1992, I have not found any information about the definition of table name, such as what kind of characters should be used, the limitation of the length. And I also browsed ISO/IEC 9075:2011, the lexical definition about token is really difficult to me, I can not understand it. Could anyone explain it for me? This question can be simplified to this one, can special characters such as period be used in table name according to the standard?

Thomas Dickey
  • 51,086
  • 7
  • 70
  • 105
Hector
  • 39
  • 6
  • https://stackoverflow.com/questions/338156/table-naming-dilemma-singular-vs-plural-names – The beginner Sep 18 '17 at 04:57
  • That link doesn't answer the question... – jarlh Sep 18 '17 at 06:39
  • Regular identifiers use A-Z, and digits [0-9] (except in first position) - not reserved words. Delimited identifiers may include all characters, e.g. `"Very 4 odd %&() name?"` and also reserved words, like `"TABLE"` (bad idea!) – jarlh Sep 18 '17 at 06:42
  • Exactly as @jarlh wrote, there's just one additional character in regular identifiers, the underscore `_` – dnoeth Sep 18 '17 at 07:21
  • @dnoeth, thanks for the correction! (I blame this morning's lack of coffee!) Also, I forgot to mention max length 128 characters,. – jarlh Sep 18 '17 at 07:27

0 Answers0