An "S" in the filter icon reflects this setting.įigure 9 shows a search for all table entries in connections : SQLiteStudio expects the value to look for in a column. : This setting supports searching by pattern. : SQLiteStudio searches all table fields for the search term. To do this, press the small arrow next to the funnel symbol next to the search field in the Grid view To search, first select how the search will take place. Of a table, you can double-click on the header of the desired column to sort the data. , SQLiteStudio suggests using the matching entries for the fields with the foreign keys if you double-click the box and select the arrow that then appears. Next, populate the tables with sample data. Section, you can make some additional fine adjustments if needed. This opens another dialog in which you select the table ( types To make these shortcuts binding for the entries in connections.typeĪs a foreign key. To avoid the need to continually write out the words Phone, Fax, or Cell in the connection data, there is a shortcut for each category. In this example, foreign keys are used for the type of connection data in connections.type This opens the window for creating the column ( Figure 2). To create a new table column, click on the appropriate icon in the toolbar of this window or press Ins
SQLITESTUDIO PL PLUS
In the tree display of the database on the left or via the table icon with the plus sign in the toolbar. The dialog for creating a database table can be opened via the Structure | Create a table If multiple databases are available later on, you will need to select the required database below DatabasesĪfter successfully connecting, SQLiteStudio shows you the database in a tree structure on the left edge of the program window. , or press the icon with the two connectors on the far left. Clicking OKīefore you can create a table, you first need to connect to the database. If the SQLite database is operational, you will see a green checkmark as confirmation. , SQLiteStudio will remember this database in your next session. If you keep the Permanent (keep it in configuration)
, the tool creates a database name from the directory name. Figure 1: SQLiteStudio dialog for creating a database.
0 kommentar(er)
