AboutDialogAbout SQLiteStudio and licensesAbout<html><head/><body><p align="center"><span style=" font-size:11pt; font-weight:600;">SQLiteStudio v%1</span></p><p align="center">Free, open-source, cross-platform SQLite database manager.<br/><a href="http://sqlitestudio.pl"><span style=" text-decoration: underline; color:#0000ff;">http://sqlitestudio.pl</span></a><br/></p><p align="center">%2<br/></p><p align="center">Author and active maintainer:<br/>SalSoft (<a href="http://salsoft.com.pl"><span style=" text-decoration: underline; color:#0000ff;">http://salsoft.com.pl</span></a>)<br/></p></body></html>LicensesEnvironmentIcon directoriesForm directoriesPlugin directoriesApplication directorySQLite 3 version:Configuration directoryQt version:Portable distribution.MacOS X application boundle distribution.Operating system managed distribution.Copy<h3>Table of contents:</h3><ol>%2</ol>BugDialogBugs and ideasReporterE-mail addressLog inShort descriptionDetailed descriptionShow more detailsSQLiteStudio versionOperating systemLoaded pluginsSendYou can see all your reported bugs and ideas by selecting menu '%1' and then '%2'.A bug report sent successfully.An error occurred while sending a bug report: %1
%2You can retry sending. The contents will be restored when you open a report dialog after an error like this.An idea proposal sent successfully.An error occurred while sending an idea proposal: %1
%2A bug reportDescribe problem in few wordsDescribe problem and how to reproduce itA new feature ideaA title for your ideaDescribe your idea in more detailsReporting as an unregistered user, using e-mail address.Reporting as a registered user.Log outProviding true email address will make it possible to contact you regarding your report. To learn more, press 'help' button on the right side.Enter vaild e-mail address, or log in.Short description requires at least 10 characters, but not more than 100. Longer description can be entered in the field below.Long description requires at least 30 characters.BugReportHistoryWindowTitleReported atURLReports historyClear reports historyDelete selected entryInvalid response from server.BugReportLoginDialogLog inCredentialsLogin:Password:ValidationValidateValidation result messageAbortA login must be at least 2 characters long.A password must be at least 5 characters long.ValidCollationsEditorFilter collationsCollation name:Implementation language:DatabasesRegister in all databasesRegister in following databases:Implementation code:Collations editorCommit all collation changesRollback all collation changesCreate new collationDelete selected collationEditing collations manualEnter a non-empty, unique name of the collation.Pick the implementation language.Enter a non-empty implementation code.Collations editor window has uncommitted modifications.ColorButtonPick a colorColumnCollatePanelCollation name:Named constraint:Enter a name of the constraint.Enter a collation name.ColumnDefaultPanelDefault value:Named constraint:Enter a default value expression.Invalid default value expression: %1Enter a name of the constraint.ColumnDialogColumnName and typeScalePrecisionData type:Column name:Size:ConstraintsUniqueConfigureForeign KeyCollateNot NULLCheck conditionPrimary KeyDefaultAdvanced modeAdd constraintcolumn dialogEdit constraintcolumn dialogDelete constraintcolumn dialogMove constraint upcolumn dialogMove constraint downcolumn dialogAdd a primary keycolumn dialogAdd a foreign keycolumn dialogAdd an unique constraintcolumn dialogAdd a check constraintcolumn dialogAdd a not null constraintcolumn dialogAdd a collate constraintcolumn dialogAdd a default constraintcolumn dialogAre you sure you want to delete constraint '%1'?column dialogCorrect the constraint's configuration.This constraint is not officially supported by SQLite 2,
but it's okay to use it.Scale is not allowed for INTEGER PRIMARY KEY columns.Precision cannot be defined without the scale.Precision is not allowed for INTEGER PRIMARY KEY columns.ColumnDialogConstraintsModelTypecolumn dialog constraintsNamecolumn dialog constraintsDetailscolumn dialog constraintsColumnForeignKeyPanelForeign table:Foreign column:ReactionsDeferred foreign keyNamed constraintConstraint namePick the foreign table.Pick the foreign column.Enter a name of the constraint.ColumnPrimaryKeyPanelAutoincrementSort order:Named constraint:On conflict:Enter a name of the constraint.Autoincrement (only for %1 type columns)column primary keyColumnUniqueAndNotNullPanelNamed constraint:On conflict:Enter a name of the constraint.CompleterWindowColumn: %1completer statusbarTable: %1completer statusbarIndex: %1completer statusbarTrigger: %1completer statusbarView: %1completer statusbarDatabase: %1completer statusbarKeyword: %1completer statusbarFunction: %1completer statusbarOperator: %1completer statusbarStringcompleter statusbarNumbercompleter statusbarBinary datacompleter statusbarCollation: %1completer statusbarPragma function: %1completer statusbarConfigDialogConfigurationSearchGeneralKeyboard shortcutsLook & feelStyleFontsColorsPluginsCode formattersData browsingData editorsDatabase dialog window<p>When adding new database it is marked to be "permanent" (stored in configuration) by default. Checking this option makes every new database to NOT be "permanent" by default.</p>Do not mark database to be "permanent" by default<p>When this option is enabled, then files dropped from file manager onto database list will be automatically added to the list, bypassing standard database dialog. If for various reasons automatic process fails, then standard dialog will be presented to the user.</p>Try to bypass dialog completly when dropping database file onto the listData browsing and editingNumber of data rows per page:<p>When the data is read into grid view columns width is automatically adjusted. This value limits the initial width for the adjustment, but user can still resize the column manually over this limit.</p>Limit initial data column width to (in pixels):<p>When this is enabled and user holds mouse pointer over a cell in any data view (query results, a table data, a view data) a tooltip will appear with details about the cell - it includes details like column data type, constraints, ROWID and others.</p>Show column and row details tooltip in data view<p>When editing a cell which used to have NULL value and entering empty string as new value, then this option determinates whether the new value should remain NULL (have this option enabled), or should it be overwritten with empty string value (have this option disabled).</p>Inserting new row in data gridBefore currently selected rowAfter currently selected rowAt the end of data view<p>When enabled, Table Windows will show up with the data tab, instead of the structure tab.</p><p>When enabled the "Data" tab will be placed as first tab in every Table Window, instead of being at second place.</p>Place data tab as first tab in a Table Window<p>When enabled, View Windows will show up with the data tab, instead of the structure tab.</p><p>When enabled the "Data" tab will be placed as first tab in every View Window, instead of being at second place.</p>Place data tab as first tab in a View WindowData typesAvailable editors:Editors selected for this data type:Schema editingNumber of DDL changes kept in history.DDL history size:SQL queriesNumber of queries kept in the history.History size:<p>If there is more than one query in the SQL editor window, then (if this option is enabled) only a single query will be executed - the one under the keyboard insertion cursor. Otherwise all queries will be executed. You can always limit queries to be executed by selecting those queries before calling to execute.</p>Execute only the query under the cursorUpdatesAutomatically check for updates at startupSessionRestore last session (active MDI windows) after startupStatus Field<p>When user manually closes the Status panel, this option makes sure that if any new message is printed in the Status panel it will be reopened. If it's disabled, then Status panel can only be open manually by the user from the "View" menu.</p>Always open Status panel when new message is printedFilter shortcuts by name or key combinationActionKey combinationLanguageChanging language requires application restart to take effect.Compact layout<p>Compact layout reduces all margins and spacing on the UI to minimum, making space for displaying more data. It makes the interface a little bit less aesthetic, but allows to display more data at once.</p>Use compact layoutDatabase listIf switched off, then columns will be sorted in the order they are typed in CREATE TABLE statement.Sort table columns alphabeticallyExpand tables node when connected to a database<p>Additional labels are those displayed next to the names on the databases list (they are blue, unless configured otherwise). Enabling this option will result in labels for databases, invalid databases and aggregated nodes (column group, index group, trigger group). For more labels see options below.<p>Display additional labels on the listFor regular tables labels will show number of columns, indexes and triggers for each of tables.Display labels for regular tablesVirtual tables will be marked with a 'virtual' label.Display labels for virtual tablesExpand views node when connected to a databaseIf this option is switched off, then objects will be sorted in order they appear in sqlite_master table (which is in order they were created)Sort objects (tables, indexes, triggers and views) alphabeticallyDisplay system tables and indexes on the listKeep NULL value when entering empty value<html><head/><body><p>Enable this to always enforce DEFAULT value when committing a NULL value for a column that has DEFAULT value defined, even though the column is allowed to contain NULL values.</p><p>Disable this option to use DEFAULT value exclusively when NULL value is committed for column with NOT NULL constraint.</p></body></html>Use DEFAULT value (if defined), when committing NULL valueTable windowsOpen Table Windows with the data tab for startView windowsOpen View Windows with the data tab for startDon't show DDL preview dialog when committing schema changesMain window dock areasLeft and right areas occupy cornersTop and bottom areas occupy cornersHide built-in pluginsCurrent style:PreviewEnabledDisabledActive formatter pluginSQL editor fontDatabase list fontDatabase list additional label fontData view fontStatus field fontSQL editor colorsCurrent line background<p>SQL strings are enclosed with single quote characters.</p>String foreground<p>Bind parameters are placeholders for values yet to be provided by the user. They have one of the forms:</p><ul><li>:param_name</li><li>$param_name</li><li>@param_name</li><li>?</li></ul>Bind parameter foregroundHighlighted parenthesis background<p>BLOB values are binary values represented as hexadecimal numbers, like:</p><ul><li>X'12B4'</li><li>x'46A2F4'</li></ul>BLOB value foregroundRegular foregroundLine numbers area backgroundKeyword foregroundNumber foregroundComment foreground<p>Valid objects are name of tables, indexes, triggers, or views that exist in the SQLite database.</p>Valid objects foregroundData view colors<p>Any data changes will be outlined with this color, until they're committed to the database.</p>Uncommitted data outline color<p>In case of error while committing data changes, the problematic cell will be outlined with this color.</p>Commit error outline colorNULL value foregroundDeleted row backgroundDatabase list colors<p>Additional labels are those which tell you SQLite version, number of objects deeper in the tree, etc.</p>Additional labels foregroundStatus field colorsInformation message foregroundWarning message foregroundError message foregroundDescription:plugin detailsCategory:plugin detailsVersion:plugin detailsAuthor:plugin detailsInternal name:plugin detailsDependencies:plugin detailsConflicts:plugin detailsPlugin detailsPlugins are loaded/unloaded immediately when checked/unchecked, but modified list of plugins to load at startup is not saved until you commit the whole configuration dialog.%1 (built-in)plugins manager in configuration dialogDetailsNo plugins in this category.Add new data typeRename selected data typeDelete selected data typeHelp for configuring data type editorsConstraintCheckPanelThe conditionNamed constraint:On conflictEnter a valid condition.Enter a name of the constraint.ConstraintDialogNew constraintconstraint dialogCreateconstraint dialogEdit constraintdialog windowApplyconstraint dialogPrimary keytable constraintsForeign keytable constraintsUniquetable constraintsNot NULLtable constraintsChecktable constraintsCollatetable constraintsDefaulttable constraintsConstraintTabModelTabletable constraintsColumn (%1)table constraintsScopetable constraintsTypetable constraintsDetailstable constraintsNametable constraintsCssDebugDialogSQLiteStudio CSS consoleDataViewFilter datadata viewGrid viewForm viewRefresh table datadata viewFirst pagedata viewPrevious pagedata viewNext pagedata viewLast pagedata viewApply filterdata viewCommit changes for selected cellsdata viewRollback changes for selected cellsdata viewShow grid view of resultssql editorShow form view of resultssql editorFilter by textdata viewFilter by the Regular Expressiondata viewFilter by SQL expressiondata viewTabs on topdata viewTabs at bottomdata viewPlace new rows above selected rowdata viewPlace new rows below selected rowdata viewPlace new rows at the end of the data viewdata viewTotal number of rows is being counted.
Browsing other pages will be possible after the row counting is done.Row: %1DbConverterDialogConvert databaseSource databaseSource database version:Target databaseTarget version:This is the file that will be created as a result of the conversion.Target file:Name of the new database:This is the name that the converted database will be added to SQLiteStudio with.Select source databaseEnter valid and writable file path.Entered file exists and will be overwritten.Enter a not empty, unique name (as in the list of databases on the left).No valid target dialect available. Conversion not possible.Select valid target dialect.Database %1 has been successfully converted and now is available under new name: %2SQL statements conversionFollowing error occurred while converting SQL statements to the target SQLite version:Would you like to ignore those errors and proceed?DbDialogDatabaseDatabase typeDatabase driverOptionsPermanent (keep it in configuration)Test connectionCreate new database fileFileName (on the list)<p>Enable this if you want the database to be stored in configuration file and restored every time SQLiteStudio is started.</p>aasfdBrowse for existing database file on local computerBrowseEnter an unique database name.This name is already in use. Please enter unique name.<p>Automatic name generation was disabled, becuase the name was edited manually. To restore automatic generation please erase contents of the name field.</p>Enter a database file path.This database is already on the list under name: %1Select a database type.DbObjectDialogsDelete tableAre you sure you want to delete table %1?Delete indexAre you sure you want to delete index %1?Delete triggerAre you sure you want to delete trigger %1?Delete viewAre you sure you want to delete view %1?Error while dropping %1: %2Delete objectsAre you sure you want to delete following objects:
%1Cannot start transaction. Details: %1Cannot commit transaction. Details: %1DbTreeDatabasesFilter by nameCopyPasteSelect allCreate a groupDelete the groupRename the groupAdd a databaseEdit the databaseRemove the databaseConnect to the databaseDisconnect from the databaseImportExport the databaseConvert database typeVacuumIntegrity checkCreate a tableEdit the tableDelete the tableExport the tableImport into the tablePopulate tableCreate similar tableReset autoincrement sequenceCreate an indexEdit the indexDelete the indexCreate a triggerEdit the triggerDelete the triggerCreate a viewEdit the viewDelete the viewAdd a columnEdit the columnDelete the columnDelete selected itemsClear filterRefresh all database schemasRefresh selected database schemaErase table dataDatabaseGroupingGenerate query for tableCreate groupGroup nameEntry with name %1 already exists in group %2.Delete groupAre you sure you want to delete group %1?
All objects from this group will be moved to parent group.Are you sure you want to remove database '%1' from the list?Are you sure you want to remove following databases from the list:
%1Remove databaseVacuum (%1)Autoincrement value for table '%1' has been reset successfully.Are you sure you want to delete all data from table(s): %1?Cannot import, because no import plugin is loaded.Cannot export, because no export plugin is loaded.Integrity check (%1)Reset autoincrementAre you sure you want to reset autoincrement value for table '%1'?An error occurred while trying to reset autoincrement value for table '%1': %2An error occurred while trying to delete data from table '%1': %2All data has been deleted for table '%1'.Following objects will be deleted: %1.Following databases will be removed from list: %1.Remainig objects from deleted group will be moved in place where the group used to be.%1<br><br>Are you sure you want to continue?Delete objectsDbTreeItemDelegateerrordbtree labels(system table)database tree label(virtual)virtual table label(system index)database tree labelDbTreeModelDatabase: %1dbtree tooltipVersion:dbtree tooltipFile size:dbtree tooltipEncoding:dbtree tooltipError:dbtree tooltipTable : %1dbtree tooltipColumns (%1):dbtree tooltipIndexes (%1):dbtree tooltipTriggers (%1):dbtree tooltipCopyMoveInclude dataInclude indexesInclude triggersAbortCould not add dropped database file '%1' automatically. Manual setup is necessary.Referenced tablesDo you want to include following referenced tables as well:
%1Name conflictFollowing object already exists in the target database.
Please enter new, unique name, or press '%1' to abort the operation:SQL statements conversionFollowing error occurred while converting SQL statements to the target SQLite version:Would you like to ignore those errors and proceed?DdlHistoryWindowFilter by database:-- Queries executed on database %1 (%2)
-- Date and time of execution: %3
%4DDL historyDdlPreviewDialogQueries to be executedDon't show againDebugConsoleSQLiteStudio Debug ConsoleEditorWindowQueryHistoryResults in the separate tabResults below the querySQL editor %1ResultsExecute queryExplain queryClear execution historysql editorExport resultssql editorCreate view from querysql editorPrevious databaseNext databaseShow next tabsql editorShow previous tabsql editorFocus results belowsql editorFocus SQL editor abovesql editorActive database (%1/%2)Query finished in %1 second(s). Rows affected: %2Query finished in %1 second(s).Clear execution historyAre you sure you want to erase the entire SQL execution history? This cannot be undone.Cannot export, because no export plugin is loaded.No database selected in the SQL editor. Cannot create a view for unknown database.Editor window "%1" has uncommitted data.ErrorsConfirmDialogErrorsFollowing errors occured:Would you like to proceed?ExportDialogExportWhat do you want to export?A databaseA single tableQuery resultsTable to exportDatabaseTableOptionsWhen this option is unchecked, then only table DDL (CREATE TABLE statement) is exported.Export table dataExport table indexesExport table triggersNote, that exporting table indexes and triggers may be unsupported by some output formats.Select database objects to exportExport data from tablesSelect allDeselect allDatabase:Query to export results forQuery to be executed for results:Export format and optionsExport formatOutputExported file pathClipboardFileExported text encoding:Export format optionsCancelSelect database to export.Select table to export.Enter valid query to export.Select at least one object to export.You must provide a file name to export to.Path you provided is an existing directory. You cannot overwrite it.The directory '%1' does not exist.The file '%1' exists and will be overwritten.All files (*)Pick file to export toInternal error during export. This is a bug. Please report it.FontEditChoose fontfont configurationFormActive SQL formatter pluginFormViewCommit rowform viewRollback rowform viewFirst rowform viewPrevious rowform viewNext rowform viewLast rowform viewInsert new rowform viewDelete current rowform viewFunctionsEditorFilter funtionsFunction name:Implementation language:Type:Input argumentsUndefinedDatabasesRegister in all databasesRegister in following databases:Initialization code:Function implementation code:Final step implementation code:SQL function editorCommit all function changesRollback all function changesCreate new functionDelete selected functionCustom SQL functions manualAdd function argumentRename function argumentDelete function argumentMove function argument upMove function argument downScalarAggregateEnter a non-empty, unique name of the function.Pick the implementation language.Per step code:Enter a non-empty implementation code.argumentnew function argument name in function editor windowFunctions editor window has uncommitted modifications.ImportDialogImport dataTable to import toTableDatabaseData source to import fromData source typeOptionsInput file:Text encoding:<p>If enabled, any constraint violation, or invalid data format (wrong column count), or any other problem encountered during import will be ignored and the importing will be continued.</p>Ignore errorsData source optionsCancelIf you type table name that doesn't exist, it will be created.Enter the table nameSelect import plugin.You must provide a file to import from.The file '%1' does not exist.Path you provided is a directory. A regular file is required.Pick file to import fromIndexDialogIndexOn table:Index name:Partial index conditionUnique indexColumnCollationSortDelete selected indexed expressionMoves selected index column up in the order, making it more significant in the index.Moves selected index column down in the order, making it less significant in the index.Edit selected indexed expressionAdd indexed expressionDDLTried to open index dialog for closed or inexisting database.Could not process index %1 correctly. Unable to open an index dialog.Unique index cannot have indexed expressions. Either remove expressions from list below, or uncheck this option.Pick the table for the index.Select at least one column.Enter a valid condition.defaultindex dialogSort ordertable constraintsErrorindex dialogCannot create unique index, because values in selected columns are not unique. Would you like to execute SELECT query to see problematic values?An error occurred while executing SQL statements:
%1IndexExprColumnDialogIndexed expressionExpression to indexThis expression is already indexed by the index.Column should be indexed directly, not by expression. Either extend this expression to contain something more than just column name, or abort and select this column in index dialog directly.Column '%1' does not belong to the table covered by this index. Indexed expressions can refer only to columns from the indexed table.It's forbidden to use 'SELECT' statements in indexed expressions.Enter an indexed expression.Invalid expression.LanguageDialogLanguagePlease choose language:MainWindowDatabase toolbarStructure toolbarToolsWindow listView toolbarConfiguration widgetsSyntax highlighting enginesData editorsRunning in debug mode. Press %1 or use 'Help / Open debug console' menu entry to open the debug console.Running in debug mode. Debug messages are printed to the standard output.You need to restart application to make the language change take effect.Open SQL editorOpen DDL historyOpen SQL functions editorOpen collations editorImportExportOpen configuration dialogTile windowsTile windows horizontallyTile windows verticallyCascade windowsNext windowPrevious windowHide status fieldClose selected windowClose all windows but selectedClose all windowsRestore recently closed windowRename selected windowOpen Debug ConsoleOpen CSS ConsoleReport a bugPropose a new featureAboutLicensesOpen home pageOpen forum pageUser ManualSQLite documentationReport historyCheck for updatesDatabasemenubarStructuremenubarViewmenubarWindow listmenubar view menuToolsmenubarHelpCould not set style: %1main windowCannot export, because no export plugin is loaded.Cannot import, because no import plugin is loaded.Rename windowEnter new name for the window:New updates are available. <a href="%1">Click here for details</a>.You're running the most recent version. No updates are available.Database passed in command line parameters (%1) was already on the list under name: %2Database passed in command line parameters (%1) has been temporarily added to the list under name: %2Could not add database %1 to list.MdiWindowUncommitted changesClose anywayDon't closeMultiEditorNull valuemultieditorConfigure editors for this data typeData editor plugin '%1' not loaded, while it is defined for editing '%1' data type.DeletedmultieditorRead onlymultieditorMultiEditorBoolBooleanMultiEditorDateDateMultiEditorDateTimeDate & timeMultiEditorHexHexMultiEditorNumericNumbernumeric multi editor tab nameMultiEditorTextTextTab changes focusCutCopyPasteDeleteUndoRedoMultiEditorTimeTimeNewConstraintDialogNew constraintPrimary Keynew constraint dialogForeign Keynew constraint dialogUniquenew constraint dialogChecknew constraint dialogNot NULLnew constraint dialogCollatenew constraint dialogDefaultnew constraint dialogNewVersionDialogSQLiteStudio updatesNew updates are available!ComponentCurrent versionUpdate versionCheck for updates on startupUpdate to new version!The update will be automatically downloaded and installed. This will also restart application at the end.Not now.Don't install the update and close this window.PopulateConfigDialogPopulating configurationConfiguring <b>%1</b> for column <b>%2</b>PopulateDialogPopulate tableDatabaseTableColumnsNumber of rows to populate:Populatepopulate dialog buttonAbortConfigurePopulating configuration for this column is invalid or incomplete.Select database with table to populateSelect table to populateYou have to select at least one column.QObjectCannot edit columns that are result of compound %1 statements (one that includes %2, %3 or %4 keywords).The query execution mechanism had problems with extracting ROWID's properly. This might be a bug in the application. You may want to report this.Requested column is a result of SQL expression, instead of a simple column selection. Such columns cannot be edited.Requested column belongs to restricted SQLite table. Those tables cannot be edited directly.Cannot edit results of query other than %1.Cannot edit columns that are result of aggregated %1 statements.Cannot edit columns that are result of %1 statement.Cannot edit columns that are result of common table expression statement (%1).on conflict: %1data view tooltipreferences table %1, column %2data view tooltipcondition: %1data view tooltipcollation name: %1data view tooltipData grid viewCopy cell(s) contents to clipboardPaste cell(s) contents from clipboardSet empty value to selected cell(s)Set NULL value to selected cell(s)Commit changes to cell(s) contentsRollback changes to cell(s) contentsDelete selected data rowInsert new data rowOpen contents of selected cell in a separate editorTotal pages available: %1Total rows loaded: %1Data view (both grid and form)Refresh dataSwitch to grid view of the dataSwitch to form view of the dataDatabase listDelete selected itemClear filter contentsRefresh schemaRefresh all schemasAdd databaseSelect all itemsCopy selected item(s)Paste from clipboardTablesIndexesTriggersViewsColumnsData form viewCommit changes for current rowRollback changes for current rowGo to first row on current pageGo to next rowGo to previous rowGo to last row on current pageInsert new rowDelete current rowMain windowOpen SQL editorPrevious windowNext windowHide status areaOpen configuration dialogOpen Debug ConsoleOpen CSS ConsoleCell text value editorCut selected textCopy selected textDelete selected textUndoRedoSQL editor input fieldSelect whole editor contentsSave contents into a fileLoad contents from a fileFind in textFind nextFind previousReplace in textDelete current lineRequest code assistantFormat contentsMove selected block of text one line downMove selected block of text one line upCopy selected block of text and paste it a line belowCopy selected block of text and paste it a line aboveToggle commentAll SQLite databasesAll filesDatabase fileReports history windowDelete selected entrySQL editor windowExecute queryExecute "%1" querySwitch current working database to previous on the listSwitch current working database to next on the listGo to next editor tabGo to previous editor tabMove keyboard input focus to the results view belowMove keyboard input focus to the SQL editor aboveTable windowRefresh table structureAdd new columnEdit selected columnDelete selected columnExport table dataImport data to the tableAdd new table constraintEdit selected table constraintDelete selected table constraintRefresh table index listAdd new indexEdit selected indexDelete selected indexRefresh table trigger listAdd new triggerEdit selected triggerDelete selected triggerGo to next tabGo to previous tabA view windowRefresh view trigger listQuitConfirmDialogUncommitted changesAre you sure you want to quit the application?
Following items are pending:SearchTextDialogFind or replaceFind:Case sensitiveSearch backwardsRegular expression matchingReplace &&
find nextReplace with:Replace allFindSortDialogSort by columnsColumnOrderSort by: %1Move column upMove column downSqlEditorCutsql editorCopysql editorPastesql editorDeletesql editorSelect allsql editorUndosql editorRedosql editorCompletesql editorFormat SQLsql editorSave SQL to filesql editorSelect file to save SQLsql editorLoad SQL from filesql editorDelete linesql editorMove block downsql editorMove block upsql editorCopy block downsql editorCopy up downsql editorFindsql editorFind nextsql editorFind previoussql editorReplacesql editorToggle commentsql editorSaved SQL contents to file: %1Syntax completion can be used only when a valid database is set for the SQL editor.Contents of the SQL editor are huge, so errors detecting and existing objects highlighting are temporarily disabled.Save to fileCould not open file '%1' for writing: %2SQL scripts (*.sql);;All files (*)Open fileCould not open file '%1' for reading: %2Reached the end of document. Hit the find again to restart the search.SqlQueryItemColumn:data view tooltipData type:data viewTable:data view tooltipConstraints:data view tooltipCannot load the data for a cell that refers to the already closed database.SqlQueryItemDelegateThe row is marked for deletion.Cannot edit this cell. Details: %1Structure of this table has changed since last data was loaded. Reload the data to proceed.Editing a huge contents in an inline cell editor is not a good idea. It can become slow and inconvenient. It's better to edit such big contents in a Form View, or in popup editor (available under rick-click menu).Foreign key for column %2 has more than %1 possible values. It's too much to display in drop down list. You need to edit value manually.SqlQueryModelOnly one query can be executed simultaneously.Cannot commit the data for a cell that refers to the already closed database.Could not begin transaction on the database. Details: %1An error occurred while rolling back the transaction: %1Tried to commit a cell which is not editable (yet modified and waiting for commit)! This is a bug. Please report it.Uncommitted dataThere are uncommitted data changes. Do you want to proceed anyway? All uncommitted changes will be lost.An error occurred while committing the transaction: %1An error occurred while committing the data: %1Error while executing SQL query on database '%1': %2Error while loading query results: %1Insert multiple rowsNumber of rows to insert:SqlQueryViewGo to referenced row in...CopyCopy as...PastePaste as...Set NULL valuesErase valuesEdit value in editorCommitRollbackCommit selected cellsRollback selected cellsDefine columns to sort byRemove custom sortingInsert rowInsert multiple rowsDelete selected rowGenerate query for selected cellsNo items selected to paste clipboard contents to.Go to referenced row in table '%1'table '%1'Referenced row (%1)Edit valueSqlTableModelError while committing new row: %1Error while deleting row from table %1: %2StatusFieldStatusCopyClearTableConstraintsModelTypetable constraintsDetailstable constraintsNametable constraintsTableForeignKeyPanelForeign table:SQLite 2 does not support foreign keys officially,
but it's okay to use them anyway.ColumnsLocal columnForeign columnReactionsDeferred foreign keyNamed constraintConstraint namePick the foreign column.Pick the foreign table.Select at least one foreign column.Enter a name of the constraint.Foreign columntable constraintsTablePrimaryKeyAndUniquePanelColumnsColumnCollationSortValid only for a single column with INTEGER data typeAutoincrementNamed constraintConstraint nameOn conflictCollatetable constraintsSort ordertable constraintsSelect at least one column.Enter a name of the constraint.TableStructureModelNametable structure columnsData typetable structure columnsPrimary
Keytable structure columnsForeign
Keytable structure columnsUniquetable structure columnsChecktable structure columnsNot
NULLtable structure columnsCollatetable structure columnsDefault valuetable structure columnsTableWindowStructureTable name:DataConstraintsIndexesTriggersDDLExport tabletable windowImport data to tabletable windowPopulate tabletable windowRefresh structuretable windowCommit structure changestable windowRollback structure changestable windowAdd columntable windowEdit columntable windowDelete columntable windowMove column uptable windowMove column downtable windowCreate similar tabletable windowReset autoincrement valuetable windowAdd table constrainttable windowEdit table constrainttable windowDelete table constrainttable windowMove table constraint uptable windowMove table constraint downtable windowAdd table primary keytable windowAdd table foreign keytable windowAdd table unique constrainttable windowAdd table check constrainttable windowRefresh index listtable windowCreate indextable windowEdit indextable windowDelete indextable windowRefresh trigger listtable windowCreate triggertable windowEdit triggertable windowDelete triggertable windowAre you sure you want to delete column '%1'?table windowFollowing problems will take place while modifying the table.
Would you like to proceed?table windowTable modificationtable windowCould not load data for table %1. Error details: %2Could not process the %1 table correctly. Unable to open a table window.Could not restore window %1, because no database or table was stored in session for this window.Could not restore window '%1', because no database or table was stored in session for this window.Could not restore window '%1', because database %2 could not be resolved.Could not restore window '%1'', because the table %2 doesn't exist in the database %3.New table %1Committed changes for table '%1' successfully.Committed changes for table '%1' (named before '%2') successfully.Autoincrement value for table '%1' has been reset successfully.Uncommitted changesThere are uncommitted structure modifications. You cannot browse or edit data until you have table structure settled.
Do you want to commit the structure, or do you want to go back to the structure tab?Table window "%1" has uncommitted structure modifications and data.Table window "%1" has uncommitted data.Table window "%1" has uncommitted structure modifications.Could not commit table structure. Error message: %1table windowReset autoincrementAre you sure you want to reset autoincrement value for table '%1'?An error occurred while trying to reset autoincrement value for table '%1': %2Empty nameA blank name for the table is allowed in SQLite, but it is not recommended.
Are you sure you want to create a table with blank name?Cannot create a table without at least one column.Cannot create table %1, if it has no primary key defined. Either uncheck the %2, or define a primary key.Cannot use autoincrement for primary key when %1 clause is used. Either uncheck the %2, or the autoincrement in a primary key.Are you sure you want to delete table constraint '%1'?table windowDelete constrainttable windowCannot export, because no export plugin is loaded.Cannot import, because no import plugin is loaded.Go back to structure tabCommit modifications and browse data.Nametable window indexesUniquetable window indexesColumnstable window indexesPartial index conditiontable window indexesNametable window triggersEventtable window triggersConditiontable window triggersDetailstable window triggersTriggerColumnsDialogTrigger columnsTriggering columns:Select allDeselect allTriggerDialogTriggerOn table:Action:<p>SQL condition that will be evaluated before the actual trigger code. In case the condition returns false, the trigger will not be fired for that row.</p>Pre-condition:The scope is still not fully supported by the SQLite database.Trigger name:When:List of columns for UPDATE OF action.Scope:Code:Trigger statements to be executed.DDLOn view:Could not process trigger %1 correctly. Unable to open a trigger dialog.Enter a valid condition.Enter a valid trigger code.Errortrigger dialogAn error occurred while executing SQL statements:
%1VersionConvertSummaryDialogDatabase version convertFollowing changes to the SQL statements will be made:BeforeAfterViewWindowQueryView name:Output column namesDataTriggersDDLCould not restore window '%1', because no database or view was stored in session for this window.Could not restore window '%1', because database %2 could not be resolved.Could not restore window '%1', because database %2 could not be open.Could not restore window '%1', because the view %2 doesn't exist in the database %3.New view %1Refresh the viewview windowCommit the view changesview windowRollback the view changesview windowExplicit column namesGenerate output column names automatically basing on result columns of the view.Add columnview windowEdit columnview windowDelete columnview windowMove column upview windowMove column downview windowRefresh trigger listview windowCreate new triggerview windowEdit selected triggerview windowDelete selected triggerview windowView window "%1" has uncommitted structure modifications and data.View window "%1" has uncommitted data.View window "%1" has uncommitted structure modifications.Uncommitted changesThere are uncommitted structure modifications. You cannot browse or edit data until you have the view structure settled.
Do you want to commit the structure, or do you want to go back to the structure tab?Committed changes for view '%1' successfully.Committed changes for view '%1' (named before '%2') successfully.Could not load data for view %1. Error details: %2Go back to structure tabCommit modifications and browse data.Could not commit view changes. Error message: %1view windowOverride columnsCurrently defined columns will be overriden. Do you want to continue?Could not determinate columns returned from the view. The query is problably incomplete or contains errors.Nameview window triggersInstead ofview window triggersConditionview window triggersDetailstable window triggersCould not process the %1 view correctly. Unable to open a view window.Empty nameA blank name for the view is allowed in SQLite, but it is not recommended.
Are you sure you want to create a view with blank name?The SELECT statement could not be parsed. Please correct the query and retry.
Details: %1The view could not be modified due to internal SQLiteStudio error. Please report this!The view code could not be parsed properly for execution. This is a SQLiteStudio's bug. Please report it.Following problems will take place while modifying the view.
Would you like to proceed?view windowView modificationview windowWidgetCoverInterrupt