On 4 Aug 2003 at 10:03, scott.marlowe wrote: > I agree, a plain truncate blasting a whole database is a very bad thing. > > however, "truncate with cascade" would be quite useful.
If we could get something simple as getting schema of a table, dropping the table and recreating empty table, then it should be easy to emulate truncate.. Or is it done that way already? Bye Shridhar -- Either one of us, by himself, is expendable. Both of us are not. -- Kirk, "The Devil in the Dark", stardate 3196.1 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match