removeCols_query6.sql

-- 25. Remove cols
	-- these cols have been duplicated and copied so don't need the
alter table nashville_housing.dbo.nash_data
drop column PropertyAddress,
			SaleDate,
			OwnerAddress,
			TaxDistrict

-- 26. View table
select *
from nashville_housing.dbo.nash_data;