Any graphical view to create VIEW in mdf over SQL Express[Answered] RSS

• • Reply
  hkbeer

  Participant

  753 Points

  2406 Posts

  Any graphical view to create VIEW in mdf over SQL Express

  Jun 08, 2017 08:30 AM|hkbeer|LINK

  I have installed SQL Express and used it to created mdf, database, table and Views successfully.

  However, in creating VIEW I now create it purely by typing SQL.

  I need to have a graphical interface like Ms Access to assist me.

  Is there any tools in the SQL Express installation that have graphic thing to assist me so I can drag field 1 in Table A to field 2 in Table 3 to show their relations etc

  I have SQL Management Studio but seems there is none. There is a database diagram but only showing table instead of helping to create new VIEWs.

  Please help...

  Thanks. I will try to credit the ones who helped but most important is we really do sincerely thanks to all who have helped.
  
  www.developerfusion.com/tools/convert/csharp-to-vb/
• • Reply
  kaushalparik...

  All-Star

  31362 Points

  7055 Posts

  Re: Any graphical view to create VIEW in mdf over SQL Express

  Jun 09, 2017 06:53 AM|kaushalparik27|LINK

  In SQL Server Management Studio, Expand your database tree on left and Right click on Views folder, click on New View.. menu option and you will get View designer UI.

  

  

  नमस्ते,
  [KaushaL] Blog Twitter [MS MVP 2008 & 2009] [MCC 2011] [MVP Reconnect 2017]
  Don't forget to click "Mark as Answer" on the post that helped you