Specify default schema in schema-bound SQL
When creating a schema-bound view, function and so on, it should be possible to specify a default schema explicitly. So instead of
create view myview with schemabinding as
select a from myschema.mytable
you could declare a default schema up front:
create view myview with schemabinding(myschema) as
select a from mytable
Then in the body of the view definition, if an explicit schema is not given, the default of myschema is used. This way the view can still be schema-bound (it does not vary with the default schema of the user calling it) but you save typing out the same schema name again and again, if the view uses lots of objects from the same schema.
Obviously if the view does refer to objects in the two-part form with an explicit schema, the default declared at the top is not used.