• No replies
6968 Posts

Pinned topic Double Quotations for Objects.

‏2013-01-15T04:56:07Z |
My question is why there is case when you need to double quote object such as name of tables of fields.

When I refer to STAFF table in SAMPLE database, for example, SQL statement, db2 => select name from staff where dept = '20' , works but I need to double quote fields and tables for a table I created under the same schema in SAMPLE database.

Can anyone give me keyword that I can search and learn more about these differences?