Database Manager


Database manager is Appframe alternative tool to Microsoft SSMS. It can be accessed by using url: /af-dbmanager


When using SSMS make sure you have setting enabled "Prevent saving changes that require the table to be re-created" . Otherwise changes might not be compatible with Updater. Microsoft article



Database Manager allows you to test, inspect, create and modify: tables, views, triggers and stored procedures. You can also simply run queries.

Key bindings

We use Monaco text editor. Press F1 to see and filter all available commands and key bindings.

You can define additional key bindings to open new query, replace selection, execute or clipboard based on your current selection. SQL Template engine is used under the hood. To open key bindings press Alt + I


Appframe365.DBManager is already included and you can use SQL fragments $definition$ and $select_top_n n=101$


Global key bindings using SQL Templates:

  • Alt + A returns referencing objects
  • Alt + C generates column list for table or a view
  • Alt + S performs appframe search
  • Alt + U shows space used for a table selected
  • Alt + E expands selected text as SQL Fragment and opens new query window
  • Ctrl + 2 generates select top 120 statement for table or view selected. includes all columns
  • Ctrl + 3 selects top 130 for table or a view selected. includes all columns
  • Ctrl + Alt + 2 generates select top 120 statement for table or a view slected. includes non system columns
  • Ctrl + Alt + 3 selects top 130 for table or a view selected. includes non system columns.
  • Ctrl + Alt + C generates column list for table or a view. sets column alias to one after "as" keyword 
  • Ctrl + Alt + D generates object definition and opens it in a new query

Related articles

Database Manager - Select All Obsolete

Updated: 13.03.2020 12.22.45

When prototyping it is very convenient to select all columns from a table or a view. so we do something like: select * from dbo.sviw_Deploy_Version All is well until this select statement ends up in production as a view. If someone alters [sviw_Deploy_Version] you must ...

Read more...

Placeholder "LocalizeWeb2016" failed