I detached a database and found it to be 150MB and the log file to be 500MB. I re-attached it, modified my deletion script, and deleted ober 100K records. When I saw there were only a few dozzen rrecords remaining, I detached the database. but I saw it's size did not drop.
How do I get it to "compact itself"? I need this to be small since it would contain the schem for 10 tables, most of which are empty.