From: Jim S. <ja...@ne...> - 2005-10-31 15:13:53
|
Sergio Samayoa wrote: >I still don't understand why RECREATE TABLE is needed. > >=BFIt is a work around because there is no TRUNCATE statement? > >=BFIt is a "super" TRUNCATE? > >=BFRECREATE TABLE can be issued even if there are objects with dependenc= ies on >the table? > >=BFOr dependencies are checked? > > =20 > I believe it is a super-delete that leaving the dependencies in place. =20 It differs from a regular delete in that the physical structures -- data=20 and index pages -- are simply deleted. This is much, much cheaper than=20 deleting records piecemeal, but some would argue that it is a little=20 unprinicpled in a multi-user environment. I'll concede the need but don't like the syntax. --=20 Jim Starkey Netfrastructure, Inc. 978 526-1376 |