Poll table locking schemes in T-SQL

Question

Is there a way to query system tables to determine which tables use which locking schemes? I looked at the columns in sysobjects but nothing popped up.

Answer 1

aargh just being an idiot:

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

Answer 2

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