Condividi tramite


Proprietà Column.AnsiPaddingStatus

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

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property AnsiPaddingStatus As Boolean 
    Get
'Utilizzo
Dim instance As Column 
Dim value As Boolean 

value = instance.AnsiPaddingStatus
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool AnsiPaddingStatus { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool AnsiPaddingStatus {
    bool get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member AnsiPaddingStatus : bool
function get AnsiPaddingStatus () : boolean

Valore proprietà

Tipo: System.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).

Osservazioni

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

[!NOTA]

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

Esempi

Utilizzo degli oggetti di database

Vedere anche

Riferimento

Column Classe

Spazio dei nomi Microsoft.SqlServer.Management.Smo

Altre risorse

CREATE TABLE (Transact-SQL)