Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!ncar!ames!amdahl!rtech!squid!robf
From: robf@squid.rtech.com (Robert Fair)
Newsgroups: comp.databases
Subject: Re: Ingres question
Message-ID: <3271@rtech.rtech.com>
Date: 2 Aug 89 12:39:20 GMT
References: <2441JKMJJ@CUNYVM>
Sender: news@rtech.rtech.com
Reply-To: robf@squid.UUCP (Robert Fair)
Organization: Relational Technology, Inc.
Lines: 25

Jack Meth writes:
>Can relations (in Ingres) be defined on the fly?

Yes. CREATE [TABLE|VIEW|INDEX] can be used at any time, including:
- Interactively in the terminal monitor.
- In embedded SQL routines.
- In 4GL frames and procedures.

There is also an interactive fill-in-the-blanks utility for creating
tables, designed for people who don't know SQL/QUEL too well.

Relations can also be created from command scripts.

INGRES remains up and fully available when a new relation is being
created - CREATE can be run just like SELECT or INSERT.
>
>-------
>Jack Meth
>John Jay College of Criminal Justice
>New York, NY 10019
>BITNET JKMJJ@CUNYVM

Robert Fair
Technical Support
Relational Technology, Inc