[Sybase] Foreigh Key/Index column
来源:互联网 发布:unity3d性能分析器 编辑:程序博客网 时间:2024/06/02 05:23
alter table SSQLquery drop constraint SSQLquery_1925867665 (queryName) REFERENCES SSQLqueryEx(queryName)
alter table SSQLquery drop foreign key SSQLquery_1925867665 (queryName) REFERENCES SSQLqueryEx(queryName)
alter table SSQLquery drop foreign key SSQLquery_1925867665 (queryName) REFERENCES SSQLqueryEx(queryName)
alter table SSQLquery add foreign key (queryName) REFERENCES SSQLqueryEx(queryName)
If there are updates to the index field(posId) of table "trade" in the sql script, actually it does not comply with current sql standard:
Prerequisites to update index field of a table:
1. The table has no constraint on the index.
2. Index field is unique.
For table "trade", the table has no constraint, but the its index field is not unique, so we can not update the index field(posId), btw, there is no error message for such operation.
- [Sybase] Foreigh Key/Index column
- amultiple-column index
- reverse key index
- mysql index and key
- Primary Key & Index
- SQL key vs index
- MySql key and index
- index和key
- Oracle composite index column ordering
- Sybase- Invalid column name '2013-09-25'.
- reverse key index、B-tree index
- PRIMARY KEY、UNIQUE KEY、INDEX区别
- PRIMARY KEY、UNIQUE KEY、INDEX区别
- PRIMARY KEY、UNIQUE KEY、INDEX区别
- mysql key primary key unique index index的区别
- Primary key and Unique index
- key,unique index,联合索引
- Oracle/DB2 null key index
- 非常好的python学习资料
- multi-threading batch updates, how to get unique identifiers
- delphi得到MAC地址
- Testbench::Run
- MVC3集成Unity 2.0
- [Sybase] Foreigh Key/Index column
- 哪些虚拟机支持Windows 8?微软为你总结
- How to resolve '_DllMain@12 already defined in xxx.obj' ?
- GRE词汇竟然六小时背一遍
- java 虚拟机的内存限制
- Android学习笔记(二四): 多页显示-SlidingDrawer的使用
- 创新工场笔试题整理
- Java调用MySQL存储过程报错
- SED 命令手册