Path: utzoo!utgpu!jarvis.csri.toronto.edu!clyde.concordia.ca!uunet!snorkelwacker!tut.cis.ohio-state.edu!uc!nic.MR.NET!thor.acc.stolaf.edu!pritchaj
From: pritchaj@thor.acc.stolaf.edu (John Pritchard)
Newsgroups: comp.databases
Subject: INGRES tools
Summary: Alter table command?
Message-ID: <10481@thor.acc.stolaf.edu>
Date: 10 Jan 90 06:59:09 GMT
References: <10477@thor.acc.stolaf.edu>
Reply-To: snissen@carleton.edu ()
Distribution: comp.databases
Organization: Carleton College, Northfield, MN
Lines: 17

The college I work for purchased the INGRES database system last
summer, and we have recently begun working with release 6.2 on VAX VMS
systems.  It seems to me there are several "holes" in the tool set; that
is, there are several essential utilities that are missing.  I would
like to hear from anyone who has built similar utilities, toward the
possibility of an application trade as well as swapping experiences. 

We are considering a portable application or procedure(s) to provide the
basic functionality of the non-standard SQL ALTER TABLE command.  This
includes renaming tables and columns, adding and deleting columns,
resizing columns, and possibly changing the datatype of columns.  A Tech
Note explains how to do this with CREATE TABLE AS, but the steps are
tedious and prone to error, for occasional users.  Does this ring any
bells?
					Sande Nissen
					Carleton College, MN
					snissen@carleton.edu