Last post Jun 09, 2017 06:53 AM by kaushalparik27
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.
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.