Sybase ADDICT

To list the tables that use datapages or datarows locking scheme, use:

select name,sysstat2
from sysobjects
where type = 'U'
and (sysstat2 & 16384 = 16384 or sysstat2 & 32768 =32768)

To list tables that use allpages locking scheme, use:

select name,sysstat2
from sysobjects
where type = 'U'
and sysstat2 & 8192 = 8192