EditTableDialog
0
0
800
600
Edit table definition
:/icons/table:/icons/table
true
-
Table
-
75
true
-
Advanced
true
Qt::ToolButtonTextBesideIcon
Qt::DownArrow
-
-
Database sche&ma
comboSchema
-
-
Without Rowid
checkWithoutRowid
-
Make this a 'WITHOUT ROWID' table. Setting this flag requires specifying a PRIMARY KEY (which can be of any type, and can be composite), and forbids the AUTOINCREMENT flag.
-
On Conflict
-
-
-
ROLLBACK
-
ABORT
-
FAIL
-
IGNORE
-
REPLACE
-
Strict
checkStrict
-
When the strict option is enabled SQLite enforces the data types of each column when updating or inserting data.
-
Qt::Vertical
0
Fields
-
-
Add
:/icons/field_add:/icons/field_add
Qt::ToolButtonTextBesideIcon
true
-
false
Remove
:/icons/field_delete:/icons/field_delete
Qt::ToolButtonTextBesideIcon
true
-
false
Move to top
:/icons/arrow_top:/icons/arrow_top
Qt::ToolButtonTextBesideIcon
true
Qt::NoArrow
-
false
Move up
:/icons/up:/icons/up
Qt::ToolButtonTextBesideIcon
true
-
false
Move down
:/icons/down:/icons/down
Qt::ToolButtonTextBesideIcon
true
-
false
Move to bottom
:/icons/arrow_bottom:/icons/arrow_bottom
Qt::ToolButtonTextBesideIcon
true
-
Qt::Horizontal
40
20
-
0
0
0
140
QAbstractItemView::AnyKeyPressed|QAbstractItemView::DoubleClicked|QAbstractItemView::EditKeyPressed|QAbstractItemView::SelectedClicked
true
QAbstractItemView::SelectItems
false
Name
Type
NN
Not null
PK
<html><head/><body><p><img src=":/icons/field_key"/> Primary key</p></body></html>
AI
Autoincrement
U
Unique
Default
Default value
Check
Check constraint
Collation
Foreign Key
<html><head/><body><p><img src=":/icons/field_fk"/> Foreign Key</p></body></html>
Index Constraints
-
-
Add constraint
:/icons/field_add:/icons/field_add
QToolButton::InstantPopup
Qt::ToolButtonTextBesideIcon
true
-
false
Remove constraint
:/icons/field_delete:/icons/field_delete
Qt::ToolButtonTextBesideIcon
true
-
Qt::Horizontal
40
20
-
true
QAbstractItemView::ScrollPerPixel
Columns
Type
Name
SQL
Foreign Keys
-
-
Add
:/icons/index_create:/icons/index_create
QToolButton::InstantPopup
Qt::ToolButtonTextBesideIcon
true
-
false
Remove
:/icons/index_delete:/icons/index_delete
Qt::ToolButtonTextBesideIcon
true
-
Qt::Horizontal
40
20
-
true
QAbstractItemView::ScrollPerPixel
Columns
Name
References
SQL
Check Constraints
-
-
Add
:/icons/field_add:/icons/field_add
QToolButton::InstantPopup
Qt::ToolButtonTextBesideIcon
true
-
false
Remove
:/icons/field_delete:/icons/field_delete
Qt::ToolButtonTextBesideIcon
true
-
Qt::Horizontal
40
20
-
true
QAbstractItemView::ScrollPerPixel
Check
Name
SQL
true
-
<html><head/><body><p><span style=" font-weight:600; color:#ff0000;">Warning: </span>There is something with this table definition that our parser doesn't fully understand. Modifying and saving this table might result in problems.</p></body></html>
true
-
Qt::Horizontal
QDialogButtonBox::Cancel|QDialogButtonBox::Ok
:/icons/field_key:/icons/field_key
Primary Key
Add a primary key constraint
Unique
Add a unique constraint
SqlTextEdit
QWidget
1
editTableName
buttonMore
comboSchema
checkWithoutRowid
checkStrict
comboOnConflict
groupDefinition
addFieldButton
removeFieldButton
buttonMoveTop
buttonMoveUp
buttonMoveDown
buttonMoveBottom
treeWidget
buttonAddIndexConstraint
buttonRemoveIndexConstraint
tableIndexConstraints
buttonBox
accepted()
EditTableDialog
accept()
261
590
157
274
buttonBox
rejected()
EditTableDialog
reject()
329
590
286
274
treeWidget
itemSelectionChanged()
EditTableDialog
fieldSelectionChanged()
137
367
411
181
addFieldButton
clicked()
EditTableDialog
addField()
79
311
79
65
removeFieldButton
clicked()
EditTableDialog
removeField()
169
311
249
63
editTableName
textChanged(QString)
EditTableDialog
checkInput()
62
48
115
3
buttonMoveUp
clicked()
EditTableDialog
moveUp()
376
311
308
235
buttonMoveDown
clicked()
EditTableDialog
moveDown()
487
311
308
235
buttonMore
toggled(bool)
widgetExtension
setVisible(bool)
97
78
159
167
checkWithoutRowid
toggled(bool)
EditTableDialog
setWithoutRowid(bool)
640
156
324
299
treeWidget
currentItemChanged(QTreeWidgetItem*,QTreeWidgetItem*)
EditTableDialog
fieldSelectionChanged()
335
475
324
299
comboSchema
currentIndexChanged(int)
EditTableDialog
changeSchema(int)
482
135
647
157
buttonRemoveIndexConstraint
clicked()
EditTableDialog
removeIndexConstraint()
119
315
647
157
buttonMoveTop
clicked()
EditTableDialog
moveTop()
283
311
202
190
buttonMoveBottom
clicked()
EditTableDialog
moveBottom()
625
311
400
186
comboOnConflict
currentIndexChanged(int)
EditTableDialog
setOnConflict(int)
516
219
490
211
checkStrict
toggled(bool)
EditTableDialog
setStrict(bool)
457
177
399
299
buttonRemoveForeignKey
clicked()
EditTableDialog
removeForeignKey()
127
299
399
299
buttonAddForeignKey
clicked()
EditTableDialog
addForeignKey()
50
299
399
299
buttonAddCheckConstraint
clicked()
EditTableDialog
addCheckConstraint()
40
299
399
299
buttonRemoveCheckConstraint
clicked()
EditTableDialog
removeCheckConstraint()
97
299
399
299
fieldSelectionChanged()
addField()
editField()
removeField()
checkInput()
itemChanged()
moveUp()
moveDown()
setWithoutRowid(bool)
changeSchema(int)
removeIndexConstraint()
moveTop()
moveBottom()
setOnConflict(int)
setStrict(bool)
addForeignKey()
removeForeignKey()
addCheckConstraint()
removeCheckConstraint()