[DB-SIG] Quoting table and column names

Ryan Weisenberger ryanw@inktomi.com
Wed, 19 Jun 2002 14:18:14 -0700

Is it safe to ALWAYS quote table names and column names in SQL 
statements?  My python app queries against several different kinds of 
databases, most notably Oracle 8 and 9, MS SQL Server 2000, and 
Sybase.  When table and column names contain spaces or characters (':' or 
'-'), I surround them with double quotes.  So is it safe to always do 
this?  I thought at one time I discovered that some dbs don't like this.

Ryan Weisenberger
Software Developer
(650) 653-4595