[SQL] schemas and paths with the alter statement

2005-02-22 Thread Theodore Petrosky
I have to first admit that I am very green at this. I thought that one could refer to a table in a fully qualified path... public.testtable I am fooling around with webobjects and EOModeler. at one point it creates the sql to create my table structure and it does something like: ALTER TABLE

Re: [SQL] schemas and paths with the alter statement

2005-02-22 Thread Ragnar HafstaĆ°
On Tue, 2005-02-22 at 11:06 -0800, Theodore Petrosky wrote: I have to first admit that I am very green at this. I thought that one could refer to a table in a fully qualified path... public.testtable ... ALTER TABLE public.test ADD CONSTRAINT public.test_PK PRIMARY KEY (test); ...