SQL Server never shrinks a database file on it's own, because it's an expensive I/O operation.
You can shrink the database (file) manually with
Note: Shrinking will cause index fragmentation and that effects query performance.
I have a table in my DB that is 30GB in size.
The disk space is not change once I drop the table , how can I do.
Please help advice.