Modules (M to SQL Mapping)

  • Article

[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.]

Microsoft code name “M”->SQL translates “M” modules to SQL schemas. Dots in module names are translated directly to schema names. All tables, functions and views generated from extents and computed values defined in a module are placed within that schema.

Examples

“M” Example SQL Example

Module

 
module M {
    MyInt : Integer32;
}
 
create schema [M];
 
create table [M].[MyInt]
(
  [Item] int not null
);

Dotted Module

 
module M.N {
    MyInt : Integer32;
}
 
create schema [M.N];
 
create table [M.N].[MyInt]
(
  [Item] int not null
);

Module imports and exports are “M” constructs and have no effect on the SQL output by “M”->SQL.