Click here to Skip to main content
15,743,934 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi Sir,

how to check space occupied by particular table in database ?

i want to find difference between delete and truncate command.

Please Help me...!!!

Thanks and Regards

Prasad Guduri
Sergey Alexandrovich Kryukov 4-Feb-12 17:20pm    
Why? Looks like a weird idea.

Use sp_Spaceused and pass table name as parameter

suppose you want to check the space used by table "Employee" then your query would be

EXEC sp_SpaceUsed Employee

Hope this helps if yes then accept the answer and vote it otherwise revert back with your queries

--Rahul D.
Share this answer
Have a look at this link[^]. Very good explanation on the differences between the two commands. :)
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900