Increasing VARCHAR Column Length

Dev Shed Forums Sponsor:

April 1st, 2004, 03:34 PM

iagal

Registered User

Join Date: Mar 2003

Posts: 16

Time spent in forums: 26 m 53 sec
Reputation Power: 0

Increasing VARCHAR Column Length

I'm sorry, but I'm in a position of which I have no php/sql knowledge and yet been asking to "handle it." *sigh* Excuse my ignorance and yes, I tried searching for the info and couldn't find it.

That out of the way...

I have a column in a sql table called "blah" and it is currently 15 varchar and I want to make it 30 varchar...

Can someone help me with the command? Thank you in advance.

edit:
I have been trying the following but obviously it is incorrect.
alter table_name modify column_name varchar(30)

Last edited by iagal : April 1st, 2004 at 04:02 PM.

April 2nd, 2004, 11:07 AM

sypher

Contributing User

Join Date: Jan 2004

Location: Montreal

Posts: 92

Time spent in forums: 15 m 10 sec
Reputation Power: 5

the syntax seem fine...make sure you're in your DB

try with Entreprise Manager, it's more user friendly and less error prone

Viewing: Dev Shed Forums > Databases > MS SQL Development > Increasing VARCHAR Column Length

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump