Ability to modify views/tables against database in new query window instead of table designer
When creating views/tables in Management Studio, we do not use the interface. We write straight t-sql in a new query window. We would like to have this option when using SQL Connect. Currently, you can do this if you use the "Edit file in project" option, but if you want to work against the database, SQL Connect forces you to use the table designer.
Caroline P. commented
Yes, that works. I did not realize that you do not have to right click and select "Add" to add a database object to source control, but instead you can execute the query then synchronize it and it will add it to your project with the name of the object. Thanks.
AdminDavid Atkinson (Admin, Red Gate) commented
You can right click on the database project node and choose 'New Query' and type in your SQL. Is this what you were hoping for?