RE: Problems creating SYNONYM

> Here we have two databases on the same server. Lets say db1 > and db2. In db1 we have a table Table1. I want to create a > synonym for Table1 in db1 on db2. > I tried: CREATE SYNONYM syn1 FROM db1:Table1 but this doesnt > work - syntax error. Change From to For. > > Can anybody help me? > > Thanks - Guido > ___________________________________________________________________________ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema Group. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema Group Helpdesk by telephone on +44 (0) 121 627 5600. ___________________________________________________________________________