.png)
ScriptingOptions.ConvertUserDefinedDataTypesToBaseType Property
SQL Server 2012
Gets or sets the Boolean property value that specifies whether user-defined data types are converted to the most appropriate SQL Server base data types in the generated script.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Property Value
Type: System.BooleanA Boolean value that specifies whether user-defined data types are converted to the most appropriate SQL Server base data types in the generated script.If True, user-defined data types are converted to SQL Server base data types. Otherwise, False (default).
The following code example specifies that user-defined data types will be converted to base data types in the script.
Visual Basic
Dim scOps As New ScriptingOptions() scOps.ConvertUserDefinedDataTypesToBaseType = true
PowerShell
$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions $scOps.ConvertUserDefinedDataTypesToBaseType = $TRUE
