|
|
| (One intermediate revision by one other user not shown) |
| Line 1: |
Line 1: |
| It would be really helpful to have a list here. In the meantime, here are some links:
| | #REDIRECT [[Development:XMLDB reserved words]] |
| | |
| * [http://www.postgresql.org/docs/current/static/sql-keywords-appendix.html#KEYWORDS-TABLE Postgres]
| |
| * [http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html MySQL]
| |
| * [http://msdn2.microsoft.com/en-us/library/ms189822.aspx MSSQL]
| |
| * [http://www.cs.umbc.edu/help/oracle8/server.815/a67779/ap_keywd.htm Oracle]
| |
| * [http://publib.boulder.ibm.com/infocenter/db2e/v8r2/index.jsp?topic=/com.ibm.db2e.doc/db2eresword.html DB2]
| |
| | |
| Even better: [http://www.petefreitag.com/tools/sql_reserved_words_checker/?word=user SQL Reserved Words Checker].
| |
| | |
| It would be really good if the new XMLdb functions checked column and table names against these lists and refused to created things with reserved words as names.
| |
| | |
| Or alternatively, if they guaranteed to escape all SQL so it did not matter if we used reserved words.
| |
