DBCC SHRINKFILE ('data_0', TRUNCATE ONLY)
DBCC SHRINKFILE ('log', TRUNCATE ONLY)

-- view used/available space
SELECT
	name,
	CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0 as SpaceUsedInMB,
	size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0 AS AvailableSpaceInMB
FROM sys.database_files