How do I get this attribute of a table? ?

cxs622

sql server, table table_A, has an nvarchar (max) field,

How do I know if the 'large value types out of row' of this table is now "on" or "off"? ?

wgfxman

When the 'large value types out of row' option of the sp_tableoption stored procedure is set to OFF, in-row storage for large value types is limited to 8000 bytes. When this option is set to ON, only the 16-byte root is stored in-line. For more information, see sp_tableoption (Transact-SQL).

See the help of sp_tableoption ~

cxs622

I want to know the current value of 'large value types out of row'. Not change.

wgfxman

Use OBJECTPROPERTY (id, TableTextInRowLimit)

wgfxman

select OBJECTPROPERTY (OBJECT_ID (N'TABLENAME '),' TableTextInRowLimit ')

cxs622

No use, 'TableTextInRowLimit' is not 'large value types out of row'

exec sp_tableoption 'table_A', 'large value types out of row', 0;
exec sp_tableoption 'table_A', 'large value types out of row', 1;

all the same.

cxs622

up.

How can I know whether the'large value types out of row' of this table is now "on" or "off"? ?

忆茹天使

OBJECTPROPERTY

忆茹天使

select OBJECTPROPERTY(object_id('sysobjects'),'TableTextInRowLimit')