How to remove User Defined Table Types SELECT 'drop type '+name FROM sys.types WHERE SCHEMA_NAME(schema_id) = 'dbo' FacebookTwitter Related