Delete tables and shrink database 1

[Jaminj]

Hello. We have a database that is 100gb in size. The validity of the data is now in question due to a server crash. I want to remove all data in the tables and reimport only the current year. Here are my questions:

1. How can I remove all data from tables? I would want the table structure to stay intact.

2. Once all data is removed how can I shrink the physical size of the database?

Thanks.

 

[SQLBill]

1. Refer to the BOL and look up TRUNCATE TABLE.

2. Refer to the BOL and look up DBCC SHRINKDATABASE and DBCC SHRINKFILE.

-SQLBill

Posting advice: FAQ481-4875

 

[Jaminj]

Thanks SQLBill. This gave me the information that I needed.