Using the CLI : Subcommands : Table commands
 
Table commands
 
Table 3: Commands for tables
delete <table_name>
Remove a table from the current object.
For example, in config system admin, you could delete an administrator account named newadmin by typing delete newadmin and pressing Enter. This deletes newadmin and all its fields, such as newadmin’s first-name and email-address.
delete is only available within objects containing tables.
edit <table_name>
Create or edit a table in the current object.
For example, in config system admin:
edit the settings for the default admin administrator account by typing edit admin.
add a new administrator account with the name newadmin and edit newadmin‘s settings by typing edit newadmin.
edit is an interactive subcommand: further subcommands are available from within edit.
edit changes the prompt to reflect the table you are currently editing.
edit is only available within objects containing tables.
end
Save the changes to the current object and exit the config command. This returns you to the top-level command prompt.
get
List the configuration of the current object or table.
In objects, get lists the table names (if present), or fields and their values.
In a table, get lists the fields and their values.
For more information on get commands, see “get”.
purge
Remove all tables in the current object.
For example, in config user local-user, you could type get to see the list of all local user names, then type purge and then y to confirm that you want to delete all users.
purge is only available for objects containing tables.
Caution: Back up the FortiADC appliance before performing a purge because it cannot be undone. To restore purged tables, the configuration must be restored from a backup.
Caution: Do not purge system interface or system admin tables. This can result in being unable to connect or log in, requiring the FortiADC appliance to be formatted and restored.
show
Display changes to the default configuration. Changes are listed in the form of configuration commands.
For more information on show commands, see “show”.
Example of table commands
From within the system admin object, you might enter:
edit admin_1
The CLI acknowledges the new table, and changes the command prompt to show that you are now within the admin_1 table:
new entry 'admin_1' added
(admin_1)#