Subject | Column names starting with underscore |
---|---|
Author | Jake Alley |
Post date | 2013-09-25T19:21:22Z |
I'm wondering about Firebird not allowing column names to start with an underscore. I have a database that works fine with Postgresql, Mysql, and Sqlite. I was excited about using Firebird as an embedded alternative to Sqlite, but have found that Firebird doesn't allow column names to start with underscores.
Am I correct about this? Is there a way to get around it?
There are lots of theories about column naming practices. The reason I use underscores occasionally to start column names is that some names I want to use are SQL key or reserved words. For instance "class" is reserved in SQL 99. It usually doesn't matter in statements, but sometimes it can cause hard to troubleshoot problems. It's easier for me to just name the column "_class."
Thanks.
Am I correct about this? Is there a way to get around it?
There are lots of theories about column naming practices. The reason I use underscores occasionally to start column names is that some names I want to use are SQL key or reserved words. For instance "class" is reserved in SQL 99. It usually doesn't matter in statements, but sometimes it can cause hard to troubleshoot problems. It's easier for me to just name the column "_class."
Thanks.