ASE : To list tables that use "datapages" or "datarows" lockign scheme

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

To list tables that use "allpages"

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