Re: Creating tables & synonyms with Des2k.

Designer/2000 1.3 is allowing you to do that but Designer/2000 2.1 isn't. I don't know why.

Try to use another names for synonyms (add additional letter for example) and edit script file after generation but before running...

I've no other solution at the moment...

Good luck.

Bill Williams wrote:
>
> I am new to designer 2000 and I am not a DBA.
>
> The company I am contracting at has decided they want to use Designer
> 2000 for a new project. In the past, when they created a table, they
> created a public synonym with the same name as the table to allow all
> users to access the new table.
>
> Designer is not allowing me to create a synonym with the same name as
> the table.
>
> Is there another way to pull this off from within Designer?

-- 
Valeri Sorokine
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru