Archives of the TeradataForum

Message Posted: Wed, 24 Jul 2002 @ 15:59:09 GMT

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

They actually can be dropped (bypassing appropriate access rights), conversion scripts do it, but this path is fraught with risks.

If you drop a table that is needed in managing your SQL statements, the DBMS winds up in a state where you can't re-create the table. This is why conversion scripts are so carefully orchestrated to make sure that at no time is the DBMS without a table that it needs to proceed and that that all tables being "messed with" are consistent. This is also why the convert diagnostic requires that the system be quiescent, etc.

I'd seek the advice of the GSC before undertaking any DDL changes in the DBC database.

Pat Belle
Teradata Certified Master

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