This is very intresting question where we need to understand on getting the complete list of tables in database is quite easy.
SELECT * FROM SYS.TABLES
This query will return the complete list of tables in the selected Database.
Now coming to the second part by indentifying the total size of the table that it occupied. Here it is.
EXEC SP_USEDSPACE "Your Table Name goes here"
The above query will return number of rows in the table, Space reserved, actual space occupied and finally the free un-used space in the table.
Asked In: Many Interviews |