Re: Changing column width of full table?
From: Tommy Wareing <p0070621_at_brookes.ac.uk>
Date: 1995/06/19
Message-ID: <3s4bkd$k1j_at_cs3.brookes.ac.uk>#1/1
Date: 1995/06/19
Message-ID: <3s4bkd$k1j_at_cs3.brookes.ac.uk>#1/1
In article <3rsbn0$uf_at_horizon.synon.com>, Raghu Valluri says...
>I believe you can change the width of attributes of data types
>CHAR and NUMBER anytime using ALTER TABLE ...MODIFY
As long as you make allowances for any data already in the table. eg. You cannot make a column NON-null if it currently contains NULLs; You cannot make a column narrower than the narrowest piece of data in that column.
-- _________________________ __________________________________________ / Tommy Wareing \ / I've been looking for an original sin, \ | p0070621_at_brookes.ac.uk X One with a twist and a bit of a spin | \ 0865-483389 / \ -- Pandora's Box, Jim Steinman / ~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Received on Mon Jun 19 1995 - 00:00:00 CEST