Deleting data from a table?

[JasonDBurke]

Is there a quick and dirty way of emptying data from tables without deleting the entire table itself. I'm sure the engineers at Microsoft built that functionality in there but I can't find it anywhere. Thanx for the help,
Jason

 

[Cagliostro]

drop table xxxmeans delete the table as is.
delete from xxx means delete data from table without deleting the table. It means it'll empty the table.

You can also delete selective
delete from xxx
where a = something
will be deleted from table xxx only data where in column a is value something. John Fill

ivfmd@mail.md

 

[tlbroadbent]

Use TRUNCATE TABLE to quickly empty a table in SQL Server.

truncate table mytable Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.