On Tue, May 3, 2011 at 9:07 PM, Thomas Steinmaurer <t...@iblogmanager.com> wrote: > Hi! > >>> ----Messaggio originale---- >>> Ogg: [Firebird-devel] List of keywords? >>> is there somewhere a list of keywords, which an tool/application >>> developer should access as delimited identifier in a dialect 3 database? >> >> Maybe you refer to >> http://www.firebirdsql.org/rlsnotesh/rlsnotes25.html#rnfb25-reswords >> >> and >> >> http://www.firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb20x-reswords > > I hoped, there is a one stop place, but I guess I have to go through the > various release notes. > > I also found this: > http://www.firebirdsql.org/doc/contrib/standardSQLkeywords.html > > While it's a list per SQL standard, it doesn't mention what Firebird > version treats what term as keyword.
Also Cosmin created a list of keywords "If anyone's interested, I attached a csv of reserved keywords (marked with '*') for 2.0.6, 2.1.3 and 2.5.0 respectively, brute-force tested using table name, column name, exception name and generator name as identifiers. The list of keywords is the union of keywords list from SQL standards 92, 99, 2003 and 2010 draft, Interbase 6, 6.5, 7 and Firebird 1.0-2.5." https://spreadsheets.google.com/ccc?key=0AgmDDYc8dMVzdDc2NnlpbUdHaWJBcU51c01wdjV3Rnc&hl=en And is always up to date in svn http://firebird.svn.sourceforge.net/viewvc/firebird/firebird/branches/B2_5_Release/src/dsql/keywords.cpp?revision=52871&view=markup Maybe it should be generated as one of the examples dbs :) and all you should do is Select * rdb$keywords or select * from keywords Old thread is here http://firebird.1100200.n4.nabble.com/Question-regarding-reserved-keywords-in-2-5-td3022079.html ------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
