[AccessD] SQL Server GUI tools

Stuart McLachlan stuart at lexacorp.com.pg
Tue Sep 8 17:46:03 CDT 2020


In SQL Server Management Studio  (using 2014)

In the  Treeview:

Server
....Databases
......MyDatabase
.........Database Diagrams

New Diagram  (Unless you've got an aappropriate one already there)
Add desired tables

Click on the "record selector" of a field in one table and drag it over a field in another table to 
create a relationship.  You will be prompted for the reationsip details.

To delete a relationship, right click on the relationship and select "Delete relationships..."
You wil be prompted for confirmation.

On 8 Sep 2020 at 21:26, John Bartow wrote:

> Since SQL Server was recently brought up...
> 
> Is there a decent tool to graphically layout tables and relationships
> similar to how the Access relationships dialog window works?
> 
> John B
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list