+8When you create a custom view in TX that is not created from a table you have to remember to start with the CREATE VIEW [schema].[view name] AS syntax and match the view name in the syntax with the view name above. This could be 100% automated, reducing the possiblity of errors.
The same situation exists with Stored Procedures.
+3Not having to write the ‘create … as’ would also solve the issue you run into when making changes to the DB schema’s (the ‘create… as’ in the view / stored procedure doesn’t change automatically now - resulting in deploy errors)
Best Regards,
Peter
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
