DEV Community

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

Posted on

2 1

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)

AWS Security LIVE!

Join us for AWS Security LIVE!

Discover the future of cloud security. Tune in live for trends, tips, and solutions from AWS and AWS Partners.

Learn More