Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in erwin® Data Modeler › Function Properties

Function Properties

The following describes new or changed properties in the property editor and related information.

SQL Azure does not support creating CLR scalar functions and CLR table-valued functions using the CREATE FUNCTION statement. SQL Azure does support creating scalar functions, inline table-valued functions, and multistatement table-valued functions without any modification.

For scalar functions and multistatement table-valued functions, function_body is subject to the general SQL Azure Transact-SQL data manipulation language (DML) limitations. The following list describes the DDLs that are subject to the general SQL Azure Transact-SQL data definition language (DDL) limitations:

• table_type_definition
• column_definition
• column_constraint
• computed_column_definition
• index_option

The following describes the impacts on the SQL Azure Function Editor as compared to the SQL Server 2008 Function Editor:

• On the General tab, Function Type drop-down, two CLR types were removed - Scalar Return Assembly Function and Table Return Assembly Function.