DEV Community 👩‍💻👨‍💻

Cover image for Check if type exists in MSSQL
Adam K Dean
Adam K Dean

Posted on

Check if type exists in MSSQL

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
Enter fullscreen mode Exit fullscreen mode

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
Enter fullscreen mode Exit fullscreen mode

More SQL snippets to come.

Top comments (0)

Head to your account's Settings to...

🌚 Enable dark mode
🔠 Change your default font
📚 Adjust your experience level to see more relevant content