Database Size
-
I have deleted some tables containing data and images from Database but database size is not reduced. any body guide me .Why not reduced?
-
I have deleted some tables containing data and images from Database but database size is not reduced. any body guide me .Why not reduced?
If you are talking about Microsoft Access database, then you can use "compact and repair" to reduce the size of your file.
-
I have deleted some tables containing data and images from Database but database size is not reduced. any body guide me .Why not reduced?
Why should it be reduced? Most databases work in this way; you deleted items in the database, you didn't make the database smaller. Any deleted items aren't "physically" removed, they're just marked as being "non-existent". Imagine a database having to remove a single string from 5 trillion others, and save a concatenated form back again. Databases are fast by doing things efficiently. No real "removals", but "marks". If you want to reclaim the space, you'll have to "shrink" your database. Access has it's way, as mentioned, and Sql Server has some sprocs.
Bastard Programmer from Hell :suss: