Name: Check if type exists in MSSQL
Rating: 3.5 (2377 reviews)
Author: adamkdean

Check if type exists in MSSQL

Adam K Dean - Mar 27 '14 -

Snippet time. Check if a type exists in MSSQL with the following simple query:

IF TYPE_ID(N'[dbo].[udt_SomeCustomType]') IS NOT NULL
BEGIN
    -- type exists, do something here
END

And of course, the other way round:

IF TYPE_ID(N'[dbo].[udt_SomeCustomType]') IS NULL
BEGIN
    -- type does not exist, do something here
END

More SQL snippets to come.