Macro Toolbox › Attribute Macros › %AttDatatype

%AttDatatype

Returns the datatype of the current attribute. For SQL Server and Sybase, you can use domains to assign a user-defined datatype. If an attribute has a user-defined datatype, then this macro provides its name.

Note: This macro is a legacy macro. Depending on your model type, we recommend that you use either %ColumnDatatype or %AttributeDatatype for new models. For more information on legacy macros and their related new macros, see the topic "Legacy Macros."

Syntax

%AttDatatype

Syntax Example

%ForEachAttribute() {

%AttName -> %AttDatatype

}

Expansion

master-number -> int

movie-copy-number -> int

general-condition -> varchar(10)

Usage

Classified as an Attribute macro.