How ot switch database used in Diagram

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
ROS
Posts: 5
Joined: Sun 20 Oct 2013 22:14

How ot switch database used in Diagram

Post by ROS » Sun 20 Oct 2013 22:25

Hi,
I am new to Studio and cannot find the way how to switch database used in Diagram tool.
When I right click in diagram, popup menu option New->Table, then it looks like new table would be added to Master database. T-SQL tab looks like "CREATE TABLE master.dbo.table1"

alexa

Re: How ot switch database used in Diagram

Post by alexa » Mon 21 Oct 2013 05:56

You would need to define the default database in the 'Database' field on the 'General' tab of the 'Database Connection Properties' dialog box (right-click the connection in Database Explorer and select 'Modify Connection...' from the popup menu). Please also see the 'How To: Create Database Connection' topic in the product's Help documentation.

The following article for another our product dbForge Studio for MySQL may be also useful: http://blogs.devart.com/dbforge/adaptin ... abase.html

Post Reply