Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

When creating new tables in a database project in VS 2012, opened sql files default to a split view. One is the T-SQL text editor view, and the other is the Design view. I've never used the design view, and probably never will. I just prefer the text editor. Is there a way to tell VS to default to the T-SQL view?

share|improve this question
add comment

2 Answers 2

I haven't found an option to turn off the design portion of the split view. Nor have I found a way to have the order of the windows remembered after closing a window, which is annoying!

However, if you want to ditch the SSDT editor completely you can change the default for .sql files in Tools/Options/Text Editor/File Extension, as shown below:

VS/Tools/Options

share|improve this answer
add comment

VS2012 T-SQL text editor default view

Alternatively you can choose the editing experience 'Microsoft SQL Server Data Tools, T-SQL Editor' for 'sql' extention files. This option will keep the T-SQL specific key word highlighting features intact when opening the file.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.