Archives of the TeradataForum

Message Posted: Fri, 18 Feb 2011 @ 15:38:38 GMT

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

There might be a couple of cases where case matters in an object name:

1) In a ANSI session, queries against DBC tables might not return what you expect since string comparisons default to case-specific. If your table is name Foo but you query dbc.tables where tablename = 'foo', you won't get anything.

2) You support framework around Teradata might be case specific. For example, if you have (semi-)automated support for object creation/push to production/etc. in Unix, case might matter.

I don't know that either of those is reason enough to not do it, though.

Dave

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