TurboDB Workbench
[Previous] [Main] [Next]

tdbwkb is a small text-based free-ware tool for managing TurboDB tables. It is available for Windows and Linux and can be downloaded at http://www.turbodb.de/. tdbwkb offers commands for
·Creating new tables  
·Modifiying existing tables  
·Show the table structure of existing tables  
·Creating indexes for a table  
·Deleting indexes for a table  
·Repair a table and its indexes  
·Deleting a table  

Running tdbwkb will show the copyright and the tdbwkb prompt where you can enter the different commands. Enter help to show a list of available commands.

Here is a sample tdbwkb session to illustrate the available features.

home/usr1>tdbwkb
dataWeb Turbo Database Workbench Version 1.0
Copyright (c) 2000 dataWeb GmbH, Aicha, Germany
Homepage http://www.dataweb.de, Mail info@dataweb.de
Type 'help' to get a list of available commands.
tdbwkb> help
  Abbreviations are not allowed. The commands are:
  altertable    Modifies an existing table.
  bye           Ends the tdbwkb session.
  cd            Changes the current directory.
  debug         Toggles debug mode.
  delindex      Deletes an index from a table.
  deltable      Deletes all files of a table.
  help          Prints this list of commands.
  newindex      Creates a new index for a table.
  newtable      Creates a new TurboDB table.
  pwd           Prints current working directory.
  repair        Rebuilds a table and all its indexes.
  tableinfo     Shows the description of a table.
  Type help <cmd> to get more specific help for a command.
tdbwkb> newtable animals S40Name,A'Land,Water,Air'Area,PImage,MDescription,N'Name'RecordId
Creating table animals.dat with these columns:
  1 S40  Name
  2 A    Area, Values = Land,Water,Air
  3 P    Image
  4 M    Description
  5 N    RecordId
tdbwkb> tableinfo animals
Retrieving structure of table animals.dat...
Table columns:
  1 S40  Name
  2 A    Area, Values = Land,Water,Air
  3 P    Image
  4 M    Description
  5 N    RecordId
Indexes:
animals.inr                   RecordId:4
animals.id                    Name:40
tdbwkb> altertable animals n2=S40Family
Restructuring table animals.dat to these columns:
  1 S40  Name
  2 S40  Family
  3 A    Area, Values = Land,Water,Air
  4 P    Image
  5 M    Description
  6 N    RecordId
tdbwkb> newindex animals byfamily Family,Name
tdbwkb> tableinfo animals
Retrieving structure of table animals.dat...
Table columns:
  1 S40  Name
  2 S40  Family
  3 A    Area, Values = Land,Water,Air
  4 P    Image
  5 M    Description
  6 N    RecordId
Indexes:
animals.inr                   RecordId:4
animals.id                    Name:40
byfamily.ind                  Family:40, Name:40