List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:July 1 2005 2:43pm
Subject:Re: View onto tables w/ identical key names
View as plain text  

> >When creating the view, use
> >CREATE VIEW viewname ( column names )
> >AS
> >select [fields]
> >
> >Instead of "*". This way, you can only return a single "mat" column
instead
> >of having that column twice in the view.
> >
>
>
> i'll try that programmatically, no way am i typing close to 1000 field
> names into the query browser   ;-)

Get yourself a GUI tool with which you can simply drag if a list of fields
:-)

I know one ... Database Workbench - www.upscene.com ;-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Thread
View onto tables w/ identical key namesLes Schaffer30 Jun
  • Re: View onto tables w/ identical key namesMartijn Tonies1 Jul
    • Re: View onto tables w/ identical key namesLes Schaffer1 Jul
  • Re: View onto tables w/ identical key namesMartijn Tonies1 Jul