HasSQLVariantColumn Property

SQL-DMO

SQL-DMO

HasSQLVariantColumn Property

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

Applies To
ReplicationTable2 Object
Syntax

object.HasSQLVariantColumn

Parts

object

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 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.