- 论坛徽章:
- 0
|
建立该表的 SQL如下:
{ TABLE unitkey row size = 1527 number of columns = 6 index size = 22 }
create table unitkey
(
indexdata char(17),
mstkey char(1425),
randnum char(17),
comkey char(33),
mackey char(33),
flag char(2)
);
create index ix100_1 on unitkey (indexdata)
using btree ;
因为在建立时没有设置LOCK MODE 所以现在要改,请问怎样才能改了它?
CREATE [TEMP] TABLE table-name
(
column-name
{
| {BYyE|TEXT} [IN {TABLE | blobspace-name]}]
-------------------------------------------------------------------------------
}
[NOT NULL] [UNIQUE [CONSTRAINT constr-name]][,...]
|
[UNIQUE (unique-column-list) [CONSTRAINT constr-name]][,...]
)
[WITH NO LOG]
[IN dbspace-name] [EXTENT SIZE extent-size]
[NEXT SIZE next-size]
[LOCK MODE {PAGE | ROW }] |
|