HasSQLVariantColumn Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The HasSQLVariantColumn property returns TRUE if the referenced table has a sql_variant column.

Syntax

object
.HasSQLVariantColumn

Parts

  • object
    An expression that evaluates to an object in the Applies To list

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetHasSQLVariantColumn(LPBOOL pRetVal);

Remarks

An application can call the HasSQLVariantColumn property to determine whether a table contains a sql_variant column. This action can be useful when preparing to replicate to a heterogeneous Subscriber, because not all heterogeneous databases support the sql_variant data type.

Note

If an application calls HasSQLVariantColumn on an instance of Microsoft SQL Server version 7.0, FALSE is returned.