"M" to SQL Mapping

[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” compiles to transact-SQL when using the /t:TSql10 switch of the compiler. This section describes the SQL that the “M” compiler emits for all supported syntax, and calls out what “M” features are unsupported in SQL compilation.

There are “M” constructs that have no translation in “M”->SQL. type, import and export have no corresponding meaning in SQL. They are used to create the tables, views or functions, and are then thrown away.

In This Section

• Basic Types (M to SQL Mapping)

• Modules (M to SQL Mapping)

• Extents (M to SQL Mapping)

• Computed Values (M to SQL Mapping)

• Expressions ("M" to SQL Mapping)