Archives of the TeradataForum

Message Posted: Fri, 24 Dec 2010 @ 15:34:03 GMT

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

Hi Meenakshi,

This is not possible in the Teradata environment. A database is permanent until you specifically drop it.

Tables can be temporary until the end of the session but that's about all.

If you wanted a database removed at a specific point in time, you'd have to schedule a job which removes all objects in the database, any child databases/users and their objects and then finally removes the database itself.

Cheers,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )

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