...a point to be remembered here that. truncate table can not have where
clause and hence
deletes all the rows from the table.so, if you are deleting selective rows
from the original table you can not use truncate table command, you will
have to use DELETE statement
RE: Difference between SQL7 and SQL 2000 ... For table having identy field, this field will be reset to 0 when truncated, so for the new rows added to the table a new identiy filled will have 1,2,3,.. ...TRUNCATE TABLE is functionally identical to DELETE statement with no WHERE clause: both remove all rows in the table. ... You cannot use TRUNCATE TABLE on a table referenced by a FOREIGN KEY constraint; instead, use DELETE statement without a WHERE clause.... (microsoft.public.sqlserver.programming)
Re: Regarding table Order ... "You cannot use TRUNCATE TABLE on a table referenced by a FOREIGN KEY...constraint; instead, use DELETE statement without a WHERE clause."... (comp.databases.ms-sqlserver)
Re: Truncate table (Delete Statement) ... >> How could you create delete statement equivalent to the truncate table ... A DELETE TABLE statement without a WHERE clause or joins is functionally ... equivalent to a TRUNCATE TABLE statement. ... logged due to extent deallocations while DELETE statement is fully logged. ... (microsoft.public.sqlserver.server)
Re: Information required ... To expand on Hari's answer, I'll give you three other differences between ...TRUNCATE has no WHERE clause - you ditch all rows, ... (microsoft.public.sqlserver.programming)
Re: Truncate one table ... That worked well on a test of one table when I tried to run the script on ... table I got an error "Cannot truncate "table_name" because it is being ...John... > Vishal Parkar... (microsoft.public.sqlserver.programming)
