Indexed Dictionary (User Defined Table Type)

Types.Dictionary.1.sql

/****** Object:  UserDefinedTableType [dbo].[IndexedDictionary] ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'IndexedDictionary' AND ss.name = N'dbo')
DROP TYPE [dbo].[IndexedDictionary]
GO

/****** Object:  UserDefinedTableType [dbo].[IndexedDictionary] ******/
CREATE TYPE [dbo].[IndexedDictionary] AS TABLE(
  [Index] [int] NULL,
	[Key] [nvarchar](255) NULL,
	[Value] [nvarchar](255) NULL
)
GO