title: Visual Studio 2012 Database Designer - Has the functionality changed?
body: <p>I recently installed Visual Studio and SQL Server 2012. I'm wondering if I'm missing something because the Database Designer doesn't seem anywhere as friendly as the old version.</p>
  
  <p>In Visual Studio 2010 when I created a  SQL User Instance (.mdf) in the App_Data directory, I was able to create tables using a nice interface that was quite similar to SQL Server Management Studio. I'd click save and everything was updated.</p>
  
  <p>In the new version:</p>
  
  <p>1) It seems to create .sql scripts instead of automatically saving my changes</p>
  
  <p>2) I have to update certain things in the TSQL window instead of the Properties area (certain things like Table Name are greyed out in Properties)</p>
  
  <p>3) Creating things like Foreign Keys and Indexes is nowhere near as trivial as it used to be.</p>
  
  <p>Am I missing something from my installation? Or is this the "new way" of doing things? If so, why has it been made, in my humble opinion, more complex?</p>