Sqlce入门1：常见使用和其他sql的区别

1.修改列

sqlce中sp_rename仅支持表的修改。

sp_rename 'oldTableName','newTableName';

In Sql Server 2005 Management Studio you have to create a new column with the new name, then you have to update it with the values from your old column and then you have to delete your old column. The last action is difficult if the column is (part of) an index.

ALTER TABLE YOURTABLENAME ADD PVPROC INTEGER (or your datatype);
UPDATE YOURTABLENAME SET PVPROC = PATHSPECIMEN.PVVALUE;
ALTER TABLE School DROP COLUMN PATHSPECIMEN.PVVALUE;

2.查看表中的列属性

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='stu';
SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='stu';

3.sqlce和其他sql的区别

• sqlce 3.5和其他sql的区别
• sqlce 3.5SP2和其他sql的区别
• sqlce 4.0和其他sql的区别