已解决问题
谷歌shuaiyongjie用户在2013.09.10提交了关于“神雕侠侣sqlite sql 修改字段类型”的提问，欢迎大家涌跃发表自己的观点。目前共有1个回答，最后更新于2024-10-31T18:01:39。表结构如下:CREATETABLE[ElemProp](
[_idElemProp]GUIDDEFAULT('{'||hex(randomblob(4))||'-'||hex(randomblob(2))||'-'||'4'||substr(hex(randomblob(2)),2)||'-'||substr('AB89',1+(abs(random())%4),1)||substr(hex(randomblob(2)),2)||'-'||hex(randomblob(6))||'}'),
[_ridElem]GUID,
[_sElemPropName]VARCh**ARDEFAULT(''),
[_sElemPropCatName]VARCh**ARDEFAULT(''),
[_nElemPropValidRule]INTEGERDEFAULT(0),
[_dElemPropMaxVal]DOUBLEDEFAULT(0),
[_dElemPropMinVal]DOUBLEDEFAULT(0),
[_nElemPropCtrlFlag]INTEGERDEFAULT(0),[_nElemPropOrder]DOUBLEDEFAULT(0),
UNIQUE([_ridElem],[_sElemPropName])ONCONFLICTIGNORE,
CONSTRAINT[sqlite_autoindex_ElemProp_2]PRIMARYKEY([_idElemProp]));
CREATEINDEX[ElemPropIndex]ON[ElemProp]([_sElemPropName],[_ridElem]);
CREATETRIGGER[DeletedLinkedElemPropVal]
AFTERDELETE
ON[ElemProp]
BEGIN
DELETEFROM[ElemPropVal]where[ElemPropVal].[_ridElemProp]=old.[_idElemProp];
END;
其中
_nElemPropOrder的字段类型错了，我想修改成integer，于是写下sql如下
altertable[ElemProp]
altercolumn[_nElemPropOrder]INTEGERDEFAULT(0);
但是执行总提示在alter附近有误，请高手指点一下，谢谢希望大家能够帮助她。
详细问题描述及疑问：表结构如下:
CREATETABLE[ElemProp](
[_idElemProp]GUIDDEFAULT('{'||hex(randomblob(4))||'-'||hex(randomblob(2))||'-'||'4'||substr(hex(randomblob(2)),2)||'-'||substr('AB89',1+(abs(random())%4),1)||substr(hex(randomblob(2)),2)||'-'||hex(randomblob(6))||'}'),
[_ridElem]GUID,
[_sElemPropName]VARCh**ARDEFAULT(''),
[_sElemPropCatName]VARCh**ARDEFAULT(''),
[_nElemPropValidRule]INTEGERDEFAULT(0),
[_dElemPropMaxVal]DOUBLEDEFAULT(0),
[_dElemPropMinVal]DOUBLEDEFAULT(0),
[_nElemPropCtrlFlag]INTEGERDEFAULT(0),[_nElemPropOrder]DOUBLEDEFAULT(0),
UNIQUE([_ridElem],[_sElemPropName])ONCONFLICTIGNORE,
CONSTRAINT[sqlite_autoindex_ElemProp_2]PRIMARYKEY([_idElemProp]));
CREATEINDEX[ElemPropIndex]ON[ElemProp]([_sElemPropName],[_ridElem]);
CREATETRIGGER[DeletedLinkedElemPropVal]
AFTERDELETE
ON[ElemProp]
BEGIN
DELETEFROM[ElemPropVal]where[ElemPropVal].[_ridElemProp]=old.[_idElemProp];
END;
其中
_nElemPropOrder的字段类型错了，我想修改成integer，于是写下sql如下
altertable[ElemProp]
altercolumn[_nElemPropOrder]INTEGERDEFAULT(0);
但是执行总提示在alter附近有误，请高手指点一下，谢谢期待您的答案，你就是当代的活雷锋,太感谢了
！