Database reserved words: Difference between revisions
From MoodleDocs
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
It would be really helpful to have a list here. In the meantime, here are some links: | It would be really helpful to have a list here. In the meantime, here are some links: | ||
* [http://www.postgresql.org/docs/ | * [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://dev.mysql.com/doc/refman/5.0/en/reserved-words.html MySQL] | ||
* [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_9oj7.asp MSSQL] | * [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_9oj7.asp MSSQL] | ||
Revision as of 00:22, 21 August 2006
It would be really helpful to have a list here. In the meantime, here are some links:
Even better: 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.
