You can filter objects in the grid using one of the following methods:Ĭlick the drop-down button in the column caption area, then select the Custom item and build a simple filter within the dialog in the following way: select a logical operator for checking the column values (like is less than, is greater than, etc) and set the value to be checked by this operator in the neighboring box then set the second condition if necessary in the following way and set the relation between these two conditions, whether both of them should be matched or just one of them use the '_' character to represent any single symbol in the condition and the '%' character to represent any series of symbols in the conditionĪfter you set a filter, the filtering panel becomes visible at the bottom of the grid where you can see the active filtering condition and easily enable or disable it by clicking the check box on the left. To reverse grouping, just drag the column name from the upper area back. Now all the records are displayed as subnodes to the grouping row value as shown in the picture. You can group grid objects by any of the columns by dragging the column header to the destination area. SQL Script Editor displays the objects as SQL definition. After the action objects are represented in SQL Editor as SQL queries (if they contain data) or as their full name in the database otherwise. The unique feature of the SQLite Maestro is an opportunity of drag-and-drop operations between Object Browser and SQL Editor, SQL Script Editor. drop several objects at once) as if it were a single object. You have an opportunity to select a batch of objects and after the object group is selected, you can operate on it (e.g. The navigation buttons allow you to open current object editor, create new or drop the existing one.Īs Object Manager the browser allows you to operate on several objects at a time. Click the column caption to sort objects by the values of this column in the ascending or descending mode. The columns correspond to the objects properties and rows correspond to the objects. The object kind to display is defined on the top of the Navigation bar. Object Browser represents database objects in a grid. Note: At least one connection to a database should be established to make Object Browser available. To open Object Browser select the Object | Object Browser main menu item. It also provides such operation as multiple selecting of objects (for copying, dropping, etc.) and the ability of using drag-and-drop operations between Object Browser and Database Explorer. Object Browser is a tool for operating on database objects designed as an extension of Database Explorer with ability to sort, group and filter the database objects.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |