Development:XMLDB reserved words: Difference between revisions
From MoodleDocs
| Line 7: | Line 7: | ||
== Some useful links == | == Some useful links == | ||
* One Universal Checker: http://www.petefreitag.com/tools/sql_reserved_words_checker/ | |||
* MySQL: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html | * MySQL: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html | ||
* PostgreSQL: http://www.postgresql.org/docs/7.3/static/sql-keywords-appendix.html | * PostgreSQL: http://www.postgresql.org/docs/7.3/static/sql-keywords-appendix.html | ||
* SQL*Server: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_9oj7.asp | * SQL*Server: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_9oj7.asp | ||
* Oracle: http://www.cs.umbc.edu/help/oracle8/server.815/a67779/ap_keywd.htm | * Oracle: http://www.cs.umbc.edu/help/oracle8/server.815/a67779/ap_keywd.htm | ||
* Escaping reserved words: http://www.ispirer.com/doc/sqlways38/Output/SQLWays-1-034.html | * Escaping reserved words: http://www.ispirer.com/doc/sqlways38/Output/SQLWays-1-034.html | ||
[[Category:Developer]] | [[Category:Developer]] | ||
[[Category:XMLDB]] | [[Category:XMLDB]] | ||
Revision as of 22:12, 28 May 2006
XML database schema > XMLDB reserved words
This page will show, once finished, a collection of reserved words that we must avoid completely inside the Moodle DB.
The list
Some useful links
- One Universal Checker: http://www.petefreitag.com/tools/sql_reserved_words_checker/
- MySQL: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html
- PostgreSQL: http://www.postgresql.org/docs/7.3/static/sql-keywords-appendix.html
- SQL*Server: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_9oj7.asp
- Oracle: http://www.cs.umbc.edu/help/oracle8/server.815/a67779/ap_keywd.htm
- Escaping reserved words: http://www.ispirer.com/doc/sqlways38/Output/SQLWays-1-034.html
