![]() I assume this is because the scripts in Stored Procdures folder are run BEFORE those in Types folder. ![]() I have user-defined types in the source control folder as well but the build process can't pick them up when building stored procedure. I'm aware that we can adopt Pre-scripts for this case but I'm not sure how to generate one without manually going through each object in the errors (and in case there is new object added in the future).ģ. AS Select DrugId, pbs.* from DrugPbs pbs Inner JoinOr sometimes a view is relying on another view cannot be built.ĭo we have an option to just ignore the error and keep the process going? ![]() The error 'Invalid object name 'DrugPbs'.' occurred when executing the following SQL:CREATE VIEW.
0 Comments
Leave a Reply. |