Solved

Specify schema for view

  • 9 February 2023
  • 1 reply
  • 47 views
P
Rank
Userlevel 2
Badge +3

All of the tables and views created by the Software Factory are created with the ‘dbo’-schema in SQL.

For reporting purposes I also have some views created directly in the database with an other schema, ‘rpt’ for example. I want to maintain these views also in SF, but I can't find (or I do overlook it) where to specify the schema. 

I see the field ‘View schema’, but that doesn't do anything. (Creation method = Template).

Does anyone know how to get this working, or is this currently not possible?

icon

Best answer by Erwin Ekkel 9 February 2023, 11:58

View original
This topic has been closed for comments

1 reply

E
Rank
Userlevel 6
Badge +16

The model does not give you an option to deviate from the dbo standard. The schema option is no longer supported nor used (we created a backlog item to have this field removed). You can create an idea in the ideas section for this, with enough votes this could be implemented in a future release.

Terms & ConditionsCookie settings