Skip to main content
Solved

Specify schema for view

  • February 9, 2023
  • 1 reply
  • 57 views

Forum|alt.badge.img+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?

Best answer by Erwin Ekkel

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.

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

Forum|alt.badge.img+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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings