Archives of the TeradataForum

Message Posted: Sat, 15 Aug 2015 @ 21:35:21 GMT

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

ALTER tablename FALLBACK; must be done individually for each existing non-FALLBACK table. You can't "alter all tables in the database" with a single statement.

MODIFY DATABASE databasename AS FALLBACK; changes the default for tables created in the future that don't explicitly state FALLBACK / NO FALLBACK.

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