Restructure table
 
Restructuring table "demo_market"
Edit fields structure

Field name Display label Type Max. size Move Edit
id ID autoinc 12 chars   [edit]  
_category Category text 64 chars [move down] [edit] [delete]
product Product text 64 chars [move up] [move down] [edit] [delete]
shortdescription Short description text 255 chars [move up] [move down] [edit] [delete]
price Price per item text 15 chars [move up] [move down] [edit] [delete]
quality Quality text 16 chars [move up] [move down] [edit] [delete]
_expires Record expiration date date 10 chars [move up] [move down] [edit] [delete]
location Location text 60 chars [move up] [move down] [edit] [delete]
phone Contact phone(s) text 64 chars [move up] [move down] [edit] [delete]
_email Owner's e-mail email 40 chars [move up] [move down] [edit] [delete]
_pwd Password text 24 chars [move up] [move down] [edit] [delete]
_add_datetime Record added datetime 19 chars [move up]   [edit] [delete]

New field name (only letters, digits and underscore):

        


Recreate table



Edit secondary indexes
New secondary index:
Name of index (only letters, digits and underscore)
Field names to include in index (comma separated)
Unique

Delete table
demo_market.def
demo_market.tr
delete all corresponding files from binary directory


Empty table
clear data (empty SQL table)
clear categories tree (empty .tr file)


Rename table

New name (only letters and digits):      

Edit table parameters



Edit treeview parameters