This setting is controlled by Options > General > Table Information > Get Table Information from. Access) or you have not enabled the system-table query feature. If the object tree shows you only “Tables and Views” and “System Tables” then either you are using a database which doesn’t have system tables (eg. You might do this if, for instance, you have created a new Schema. the Refresh icon in the toolbar is used to reload the information in the Object Tree from the database.Clicking on the Objects icon in the Toolbar will hide or redisplay the object tree. The object tree can be hidden, to maximize valuable screen real-estate for the two grids.The same applies to some “simple” databases (such as Access and MySQL), for which tables do not have a schema. When you click on those object icons in the Database Explorer, the object list is populated. Tablespaces and Users are examples of these. Some object-types do not have a schema associated with them.When you click on a Schema in the object tree, the object list will show all the objects (eg.You could think of them as being folders used to group and organize the objects of that object-type (however, unlike files, the objects can’t be moved from one folder to another). This high-level grouping is called the Owner, Creator or Schema (depending on the terminology of your database). When you click in the object tree on an object icon (such as Table), the high-level grouping of the object is populated.The object tree shows the different types of objects in your database (Tables, View etc), each represented by a particular icon.
Tableplus diagram generator how to#
The section How to use Grids in AQT explains how grid columns are sized. the grid columns will automatically adjust their width to the size of the data.These settings are retained from one AQT session to the next. you can adjust the pane borders between the grids and resize the screen.you can set the fonts used in the grids with Options > Database Explorer > Appearance.you can set a number of options for the appearance of the Object List and Object Details displays.This will depend on the way AQT has been configured for the database. the objects displayed by the Database Explorer window is different for every database type.the Object Details in the right grid shows the properties of the object that has been selected in the object display.
Tableplus diagram generator full#
Full use of the Admin Component is limited to the Extended Edition of AQT. tables) for a selected object-type.Ībove the Object Display is the Admin toolbar this provides the ability to manage the object selected in the object display. the Object list in the middle grid lists all the objects (eg.This box lists all databases within the current server – you can select one of these to switch to that database. If the system-table query feature is not been enabled, or has not been configured for your database, you will only see Tables, Views and System tables in this object list.įor some databases (SQL Server, Sybase, Informix, MySQL, HP SQL/MX, Netezza), the Database listbox will appear above the object tree. When you click on an object, you will be shown all the schemas within that object. the Object tree/schemas on the left shows the different types of objects in your database (Tables, Views, Indexes, Triggers etc).the following description is generic, to give a general guide.
What you see in this window will depend on the type of database you are connecting to, and how AQT has been customized. This shows you all the objects in your database. Once you sign onto a database, you will be shown the Database Explorer window.
0 kommentar(er)
