Received: from hotmail.com (dav16.law15.hotmail.com [64.4.22.120]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB5D6Lm73880 for ; Wed, 5 Dec 2001 08:06:21 -0500 (EST) (envelope-from tinarajraj@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 5 Dec 2001 05:06:24 -0800 X-Originating-IP: [203.197.173.12] From: "tinar" To: Subject: how to chane the type Date: Wed, 5 Dec 2001 18:42:07 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0005_01C17DBC.8A4BED80" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Message-ID: X-OriginalArrivalTime: 05 Dec 2001 13:06:24.0580 (UTC) FILETIME=[A470C840:01C17D8D] X-Archive-Number: 200112/73 X-Sequence-Number: 5896 This is a multi-part message in MIME format. ------=_NextPart_000_0005_01C17DBC.8A4BED80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable i have created a table userlist with fields username varchar(10) now i want to change it to username varchar(30) without dropping or recreating the table. how do i do it? tina ------=_NextPart_000_0005_01C17DBC.8A4BED80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
i have created a table
userlist with fields username=20 varchar(10)
now i want to change it to username=20 varchar(30)
without dropping or recreating the=20 table.
how do i do it?
tina
------=_NextPart_000_0005_01C17DBC.8A4BED80--