Re: Views!

Could you give me an example as to how to do it in SQL?
CREATE TABLE myschema.mytable (
table1, table2,table3......table17
);

Also can i do querying against a schema/view?

Thanks,
Hrishi

On Tue, 29 Mar 2005 17:16:33 +0000, Ragnar Hafstað <gnari(at)simnet(dot)is> wrote:
> On Tue, 2005-03-29 at 11:48 -0500, Hrishikesh Deshmukh wrote:
>
> [rearranged]
>
> > On Tue, 29 Mar 2005 09:01:24 -0500, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:
> > > On Mar 29, 2005, at 8:27 AM, Hrishikesh Deshmukh wrote:
> > >
> > > >
> > > > I have 254 tables, i want to "subset" it in 237 and 17 tables?!
> > > > Is creating views the answer?/ Is there a better way to "subset" them?
> > >
> > > Have a look at schemas:
> >
> > I have go through the docs; what you are suggesting is that take 237
> > tables and add them into a schema!
>
> maybe less work to move the other 17 tables.
>
> gnari
>
>