Re: Viewing existing lock mode
Wendy Alm wrote:
>
> We are trying to find out if a table in the database has row, table or
> page locking. We are running with on-line version 5.02. Is there
> anyway we can look this up on the current database? Thanks for your
> help in advance.
A table can use either row level (same as SE) or page level locking. To list the tables
and their respective settings, use:
SELECT tabname, locklevel
FROM systables
WHERE tabid > 99 -- Ignore system tables
AND tabtype = "T" -- Only look at tables
The locklevel field is set to 'R' for row level, and 'P' for page level locking. You can
change the lock level by using ALTER TABLE.
Cheers,
--
Mark.
+-------------------------------------------------------------------------+
|Mark D. Stock - The West Solutions Group http://www.west.co.za |
| |
|mailto:marks@west.co.za +------------------------------------------------+
|Tel: +27 11 803 2151 |If it doesn't work... force it! |
|Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! |
|Cell: +27 83 250 2325 |Well, that's how I code anyway! |
+------------------------+------------------------------------------------+