how to do database cleaning in sql server2005??? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

how to do database cleaning in sql server2005???

Author

Topic

samsun125
Yak Posting Veteran

63 Posts

Posted - 2008-10-01 : 03:18:36

Hi all,

how to do database claning , any bosy knows plz help me

ex:

database name:xyz

table name:abc

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-10-01 : 03:19:55

USE xyz
GO

DROP TABLE Table1

or

TRUNCATE TABLE Table1

or

DELETE
FROM Table1

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources