Sql Queries for Database help

1. ///// Get store procedure using sql query

       sp_helptext DeleteEmployee

2. ///// Get used spaces in database

   exec sp_spaceused

3. ///// Get ldf and mdf information and path

   EXEC sp_helpdb @dbname= 'Test'

4. ///// Remove or shrink extra space from Database.

DBCC SHRINKDATABASE(Test, 10)