lockscheme( ‘table_name’ | ‘table_id’ [, db_id] )
Returns the specified table’s lock scheme (allpages, datapages or datarows).
allpages
datapages
datarows
Example
select name as TableName from sysobjects where lockscheme(id) = 'datarows'
