Can I default to T-SQL only view in VS 2012?

Question

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?

Answer 1

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:

Answer 2

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.