Export (0) Print
Expand All

Column.AnsiPaddingStatus Property

Gets a Boolean property value that specifies whether the ANSI_PADDING_ENABLED column option is active.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Matrix)]
public bool AnsiPaddingStatus { get; }

Property Value

Type: Boolean
A Boolean value that specifies the whether the ASNI_PADDING_ENABLED column option is active. If True, trailing blanks inserted into variable-length columns are not trimmed. Otherwise, False (default).

This property specifies whether trailing blanks in variable-length columns are trimmed.

NoteNote

The value of the AnsiPaddingStatus property is ignored by columns based on the UserDefinedTableType.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft