Check out the solution in the video Error: Incorrect syntax near the keyword 'SCHEMA'. and what we do to solve this. This error may arise relative to the other T-SQL around it. Also, keep in mind that this may not be a syntax issue in future editions of SQL Server. Remember, that the use of other schemas will mean that we have to add additional filters to anything that dynamically looks at table names and we may see errors related to being unable to find the table.
Check out the highest-rated Automating ETL course on Udemy, if you're interested in data.
Schemas may be one technique that we can use to organize our data along with security. There are advantages and disadvantages of using them for this purpose. In the context of security, they may provide limited access or easier access restrictions in some cases. Still, it's not a one-step stop against digital attacks and there are numerous countermeasures or counter strategies that can be used against this design technique.
YouTube | Automating ETL | T-SQL In 2 Hours | Consumer Guide To Digital Security