Link to home
Start Free TrialLog in
Avatar of ethar turky
ethar turkyFlag for Saudi Arabia

asked on

execute alter on another database

Dear all ,
Need to execute
  
alter [testTable]    drop column ColName ;

Open in new window

which is belong to [Test2DB] while I am in context of [Master1DB].

I try to use :
  
alter [Test2DB].[testTable]    drop column ColName ;

Open in new window

and
  
alter [Test2DB].[dbo].[testTable]    drop column ColName ;

Open in new window


btw, I have  [testTable], ColName  in both database and all necessary permissions...
Also I don't want to use "USE" keyword.

thanks in advance.
Avatar of Sharath S
Sharath S
Flag of United States of America image
This query should work.

alter [Test2DB].[dbo].[testTable]    drop column ColName ;  

Did you try?
Avatar of ethar turky
ethar turky
Flag of Saudi Arabia image

ASKER

yes I try as written above and I got the error:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'Test2DB'.
ASKER CERTIFIED SOLUTION
Avatar of Rajkumar Gs
Rajkumar Gs
Flag of India image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of QuinnDex
QuinnDex
ALTER TABLE [Test2DB].[dbo].[testTable]  DROP COLUMN ColName ;