System Functions MSSQL Tutorial

sp_droptype typename    
GO