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.
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:
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