How do we check the locking scheme for a specific table?

[linnichole]

How do we check the locking scheme for a specific table? Is
there a SQL command we can run? Or is there a system table
that contains this information?

Thank you,

Nichole L.

[ThanksButNo]

sp_help {tablename}
go

[linnichole]

Okay, that was simple. Now I feel kinda dumb for not
knowing that. :)

Many thanks! :)

[Bret Halford]

Lin Nichole wrote:
> Okay, that was simple. Now I feel kinda dumb for not
> knowing that. :)
>
> Many thanks! :)
>

You can also get the information using a simple query against
sysobjects. Allpages tables that were created prior to 11.9.x
don't have any of the three bits set, thus '0'.

select case (sysstat2 & 57344)
when 0 then 'Allpages'
when 8192 then 'Allpages'
when 16384 then 'Datapages'
when 32768 then 'Datarows'
end as 'Lock Schema'
from sysobjects where type='U'
and name = "Mytable"

[Sherlock, Kevin]

Or use the "lockscheme()" builtin as in:

select lockscheme(id)
from sysobjects
where type = "U"
and ...

"Bret Halford" <br...@sybase.com> wrote in message
news:48a303a3$1@forums-1-dub...

[ThanksButNo]

On Aug 13, 1:38 am, Lin Nichole wrote:
> Okay, that was simple. Now I feel kinda dumb for not
> knowing that. :)

Don't feel dumb. That's why we come to these forums, to learn stuff.

[linnichole]

Thank you! :)

[linnichole]

Bret,

Thank you for the below SQL statement. The below SQL is
very helpful and want to send our many thanks for your help.

Thank you,

Nichole L.

[linnichole]

Kevin,

Thank you for providing the below Sybase function
information / recommendation. It has turned out to be a
great way to get back results quickly for all tables.

Many Thanks!

Nichole L.