Archives of the TeradataForum

Message Posted: Wed, 10 Oct 2001 @ 12:45:48 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

No, they can be used anywhere you want to use a reserved word in a non-reserved way. For instance:

select "date" from table_with_bad_column_names;
drop table "old_table"; /* Yes, this is a reserved word! */
create table "temporary".useless_table;

This function of double quotes also appears in DB2, so I suspect it may be part of the ANSI standard.

--wgr

	<Prev	Next>		<<First	<Prev	Next>	Last>>