Datatype: KrystianUDTType

Properties

Property	Value
Name	KrystianUDTType
ID	265
Schema	dbo
Owner	dbo
User Defined
Native Datatype
Max Length (in bytes)	14
Nullable
Is Assembly Type
Is Table Type

Extended Properties

Name	Value
MS_Description	asd - mobi update

Bound Defaults

No defaults bound to that datatype

Bound Rules

No rules bound to that datatype

Assembly File Names

Property	Value
Assebly File ID	1
File Name	KrystianUDT
Assebly File ID	2
File Name	KrystianUDTType.cs
Assebly File ID	3
File Name	Properties\AssemblyInfo.cs
Assebly File ID	4
File Name	bin\Debug\KrystianUDT.pdb

[KrystianUDTType] is used in the following columns

Column Name	Object Name	Description	ANSI Padded	Is Rowguidcol	Is Identity	Is Computed	Is Filestream	Is Replicated	Is Non Sql Subscribed	Is Merge Published	Is DTS Replicated	Is Xml Document	Is Sparse	Is Column Set
column1	dbo.test_table

[KrystianUDTType] is used in the following parameters

Datatype is not used in any parameters

Objects that depend on [KrystianUDTType]

Objects on which [KrystianUDTType] depends

SQL

Script
CREATE TYPE [dbo].[KrystianUDTType] EXTERNAL NAME [KrystianUDT].[KrystianUDTType] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'asd - mobi update' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TYPE',@level1name=N'KrystianUDTType' EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFile', @value=N'KrystianUDTType.cs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TYPE',@level1name=N'KrystianUDTType' EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFileLine', @value=N'62' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TYPE',@level1name=N'KrystianUDTType'

Script

CREATE TYPE [dbo].[KrystianUDTType] EXTERNAL NAME [KrystianUDT].[KrystianUDTType]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'asd - mobi update' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TYPE',@level1name=N'KrystianUDTType'
EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFile', @value=N'KrystianUDTType.cs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TYPE',@level1name=N'KrystianUDTType'
EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFileLine', @value=N'62' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TYPE',@level1name=N'KrystianUDTType'