Operations with Tables

Select Database (DB). After the selection you will see list of tables in the database.

At the moment you click some table, you will preview it.

You can create new table, rename and drop tables.

Rename table

Press F2 to rename table name. If you press F2 again, table with Tables will exit from editing more.

Note: Please be informed that after creation of new table, renaming of table or dropping of table (dropped table will disappear from the table), physically the table will not be created, renamed or deleted. The actions will be performed only when you confirm it by choice "Save changes" toolbar button. Or you can decline the actions by choice "Decline changes" toolbar button.

The possible actions with the tables located in Toolbar, Tables part:

All content of table is deleted. After run of the procedore, the system requires to confirm the deletion. This is undoable process, and the deletion is not confirmed via save or decline of changes.

Create new table

Empty table is created. Initially 4 fields are added to new table:

_id: uniqueidentifier, primary key. Standardly, Teide uses _id field as predefined or default field for surrogate key of tables. This allows you not to think about the assignment of fields as primary key. _id plays role of surrogate key. Traditionally, theory of relational databases does not recommend the creation of surrogate keys, however surrogate key is simple and practical way, and so this approach outweighs theoretical preferences.

_pos: int, null allowed. Standardly, Teide uses _pos field as predefined field for assigned ordering. In general, ordering field is not assigned field in relational tables - the ordering is specified as necessary, situationally in queries. But in case of "emulating" Excel-tables or inserting of new records from other table, it is expected that the ordering will be adopted as part of row property. _pos field is assigned to keep this property.

_timestamp: datetime, null allowed. Standardly, Teide uses _timestamp as predefined field to specify when record is created.

Field1: nvarchar(250), null allowed. User defined field

Obviously that after creation of the table you will need to specify fields you need. Open Field window, enter needed fields with all necessary field properties, and save the changes.

Note: Preview of newly created table, opening of list of field is available after save changes only, i.e. after physical creation of the table.

Paste to new table

New table is created based on table structure in clipboard, then table from clipboard is saved to newly created table.

When you run this procedure, you need to enter table name in opened window. New table will have _id, _pos, _timestamp fields (see Create new table chapter for details of the fields), and Field001..Fieldxxx, depending on number of columns in clipboard.

All Fieldxxx fields have nvarchar(250) type, null allowed.

Clipboard content is saved to the table. _pos field keeps order number of row in clipboard.

The table created via Paste to new table is not required to additional saving of changes.

Copy table

Table is completely copied to new table including structure and content. Relations are not copied.

Create table with current structure

New table is created with structure (fields) the same as selected table.

Drop table

Selected table deletes. Save changes to physical deletion of the table. Or decline changes to cancel the deletion.

Clear table

Refresh list of tables

The system re-load list of tables.