From: Brian R. <br...@se...> - 2004-09-13 17:30:56
|
Does SQL-Object check for reserved words prior to the creation of a table? Not only those in the SQL standards, but those specific to a database. If so, this list should include words from all supported databases and cross check these. For example, I used the word 'leading' in my SQLite database. When switching the connection to MySQL, I got an error. The error was not all that helpful. However I see on the MySQL site that 'leading' is a reserved word. Not a big deal, but thought I would let you know. Thanks, Brian SQLite keywords: http://www.sqlite.org/lang.html MySQL: http://dev.mysql.com/doc/mysql/en/Reserved_words.html Postgres: http://www.postgresql.org/docs/7/interactive/syntax.htm firebird:http://www.ibexpert.info/firebird/documentation/ Firebird%20Release%20Notes%20v1.5/New%20Reserved%20Words/18057.html |