The query editor keeps the connection of older login if I disconnect and reconnect with a new login-CodePudding

When I disconnect using Object Explorer and then I reconnect using another login (with SQL Server Authentication) the connection of the query editor remains tied with the old login.

Is there a way to sync the connections in a way that if I disconnect under Object explorer and then reconnect using another login, the connection of query editor also changes to the current login?

CodePudding user response：

I've found that in order to reopen all sql scripts with another connection I had to go to File->Open->File with New Connection

CodePudding user response：

QuerySQL(DB, "create table if not exists Accounts ( Name TEXT, LowerName TEXT, Password VARCHAR(255), Level NUMERIC DEFAULT 1, TimeRegistered VARCHAR(255) DEFAULT CURRENT_TIMESTAMP, UID VARCHAR(255), IP VARCHAR(255), AutoLogin BOOLEAN DEFAULT true ) ");