RKdsYAHg

1IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'IDListTableType' AND ss.name = N'dbo')
2DROP TYPE [dbo].[IDListTableType]
3GO
4
5IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'IDListTableType' AND ss.name = N'dbo')
6CREATE TYPE [dbo].[IDListTableType] AS TABLE(
7    [ID] [int] NOT NULL,
8    UNIQUE NONCLUSTERED 
9(
10    [ID] ASC
11)WITH (IGNORE_DUP_KEY = OFF)
12)
13GO