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.
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] BlogTwitter [MS MVP 2008 & 2009] [MCC 2011] [MVP Reconnect 2017]
Don't forget to click "Mark as Answer" on the post that helped you
Member
737 Points
2362 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...
www.developerfusion.com/tools/convert/csharp-to-vb/
All-Star
31342 Points
7050 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