Reserved Words (Master Data Services)


Applies To: SQL Server 2016

In Master Data Services, when you create model objects or members, some words cannot be used. Using these words may cause errors.

System_CAPS_ICON_note.jpg Note

You should also limit your use of special characters (symbols, hyphenation, etc.).

If you create a model with the name set to Name or Code, do not select Create entity with same name as model because Name or Code cannot be used for the name of an entity.

For entity names, you cannot use Name or Code.

For explicit hierarchy names, you cannot use Name or Code.

  • ID

  • Code

  • EnterUserName

  • LastChgUserName

  • Name

  • EnterDTM

  • EnterUserID

  • EnterUserName

  • LastChgDTM

  • LastChgUserID

  • Status_ID

  • ValidationStatus_ID

  • Version_ID

For members, you cannot use MDMMemberStatus, MDMUnused, or ROOT for the Code attribute value.

Master Data Services Overview (MDS)

Community Additions