interrogating table lock schemes in T-SQL

Question

Is there some means of querying the system tables to establish which tables are using what locking schemes? I took a look at the columns in sysobjects but nothing jumped out.

Answer 1

take a look at the syslockinfo and syslocks system tables you can also run the sp_lock proc

Answer 2

aargh, just being an idiot:

SELECT    name, lockscheme(name)
FROM      sysobjects
WHERE     type="U"
ORDER BY  name

Answer 3

The recommended way is to query the dynamic management view (DMV):

select * from sys.dm_tran_locks