Is it possible to change schema for tables in database for AX 4.0 and 2009 in SQL Server 2005?

  • Article

By default all tables in AX 4.0 and 2009 databases are stored in dbo schema in SQL Server 2005. But what if we need to change this schema. Is it possible to change it?

The answer is No as the method xSession::getDbSchema() always returns DBO.  As this value is hard-coded there's no option to change the database schema.

Martin F