How to: View a Deployed "M" Model in the Database
[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]
This is the third of five tasks that create a data-driven application by using the SQL Server Modeling CTP technologies. For an overview of this tutorial, see Getting Started with the SQL Server Modeling CTP (SetupApplication Tutorial).
In this task, you will examine the SetupApplication model in the SetupApplicationDB database by using SQL Server Management Studio. For more information about how to load this model into SQL Server, see How to: Load a Model into a SQL Server Database.
Note
You can also use Microsoft code name “Quadrant” to view the model and model instances. For more information about using “Quadrant” with the SetupApplication model, see How to: View and Edit Models Using "Quadrant".
To view a model in SQL Server Management Studio
In SQL Server Management Studio, in the Connect to Server dialog, type the Server name of the instance of SQL Server that contains the SetupApplicationDB database. If you are connecting to the instance on the current machine, you can specify
(local)for the server name.Specify the Authentication properties, and then click the Connect button.
If the Object Explorer window is not displayed, click the View menu and then click Object Explorer.
In Object Explorer, expand Databases, SetupApplicationDB, and Tables. You should see a list of tables in the SetupApplicationDB database.
Scroll through the list of tables, and look for tables that are prefixed with “SetupApplication”. The
SetupApplicationmodule in “M” becomes a SetupApplication schema that contains all the database objects in the model.Tip
You may notice other schemas in the new SetupApplicationDB, such as Language.Catalog and Language.Catalog.Runtime. These schemas are part of the “M” catalog that supports features of “M” and the tools that work with “M”.
Observe that the tables in the SetupApplication schema correspond to the extents in the original “M” model.
Expand the SetupApplication.Components tables, and then expand the Columns folder. The fields in the “M” extents are columns in the SetupApplication tables.
To view a model instance in SQL Server Management Studio
In Object Explorer, right-click any of the SetupApplication tables, and then click Select Top 1000 Rows. The content of the view is displayed in the results pane.
Note
Note that after you first load the SetupApplication model, there are no model instances, so nothing will be displayed for this step.
The next task adds data related to a setup application to this model in the SetupApplicationDB database. For more information, see How to: Add Model Instances using "M". Note that after that task, you can use the steps in this topic to view the model instance data.