Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Tools - Object Search |
| Version | 14.0 |
Database version: SQLite3
Aqua Data Studio 14.0.0-rc-44
Build #: 34314
Built on: 2013-Oct-03 04:42:13 PM
Windows 7: 64 bit
Step 1: Connect to SQLite.
Step 2: Right click on Schema -> Select Tools option -> Object search
Here you will observe that, “Column Name”, ”Indexed Columns” and ”Constraint Columns” options missing in object search window of Object Search, in SQLite.
|
|
456 KB
This is a limitation of SQLite. You can create indexes, check and unique constraints with the CREATE TABLE statement, but there is no system table or command to retrieve the constraints. We use the available system tables and commands to retrieve meta data of SQLite. We don't parse the CREATE TABLE statement to figure out what the meta data is. Indexed and Constraint columns cannot be found, the reason why we have the current design.
Issue #10454 |
| Closed |
| Won't Fix |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
This is a limitation of SQLite. You can create indexes, check and unique constraints with the CREATE TABLE statement, but there is no system table or command to retrieve the constraints. We use the available system tables and commands to retrieve meta data of SQLite. We don't parse the CREATE TABLE statement to figure out what the meta data is. Indexed and Constraint columns cannot be found, the reason why we have the current design.