From f834bfb9b878c622f5aabeec169c3f2af8c81e25 Mon Sep 17 00:00:00 2001 From: stuconnolly Date: Wed, 17 Mar 2010 16:34:47 +0000 Subject: Consolidate all localizable content in the Resources/ directory and only use Interfaces/ for XIBs. This addresses the first point on issue #593. --- Resources/Help/topics/tables.html | 89 +++++++++++++++++++++++++++++++++++++++ 1 file changed, 89 insertions(+) create mode 100755 Resources/Help/topics/tables.html (limited to 'Resources/Help/topics/tables.html') diff --git a/Resources/Help/topics/tables.html b/Resources/Help/topics/tables.html new file mode 100755 index 00000000..3840bb26 --- /dev/null +++ b/Resources/Help/topics/tables.html @@ -0,0 +1,89 @@ + + +Sequel Pro Help - Managing Tables + + + + + + + + +
+ + + + + + + + + +
+ +

Managing Tables

+
+ +
+ +
+ + Back to the main menu +
+
+ + In order to perform actions with tables, you must first choose the "Structure" tab. +
+
+Adding and Editing Fields + + + + +
+ +
    +
  • Add fields with the plus-button and drop them with the minus-button.
    • +
  • Edit fields by double-click on the value you want to change. To cancel editing hit the esc-key.
    • +
  • Changes aren't written to the database until you deselect the row!
    • +
  • You can also drag & drop fields to change their order (if they are not indexed).
    • +
+
+ +
+
+Adding, editing, removing and copying tables + + + + +
+ +
    +
  • Add or remove tables with the plus- and minus-buttons.
    • +
  • If you add a table, Sequel Pro creates a field called "id" because a table must have at least one column. You can change or delete this field afterwards.
    • +
  • Change the name of a table by double-clicking on it. Hit the esc-key to cancel editing.
    • +
  • Select a table and hit the copy button under the list of tables to copy it. If you mark "Copy table content", the new table will also contain all entries of the old table.
    • +
+
+ +
+
+Adding and editing indexes + + + + +
+ +
    +
  • Add indexes with the plus-button and drop them with the minus-button.
    • +
  • Select "Key Type", "Key Name" and "Indexed Columns" in the sheet. If you don't specify a key name, the column name is used as name.
    • +
  • If you want to make an index of more than one column, enter them in the appropriated field separated by commas (without whitespace after the comma!).
    • +
+
+ + + + + \ No newline at end of file -- cgit v1.2.3