Re: SQL Humor

From: David Cressey <david.cressey_at_earthlink.net>
Date: Sat, 27 Aug 2005 05:59:18 GMT
Message-ID: <WiTPe.2926$FW1.465@newsread3.news.atl.earthlink.net>

"AK" <AK_TIREDOFSPAM_at_hotmail.COM> wrote in message news:1125067534.738108.209370_at_g43g2000cwa.googlegroups.com...
> changing a varchar(9) to varchar(10) is supposed to be a snap.
> I would not be that optimistic about a change from char(9) to char(10)
>

This is DBMS dependent. In Rdb/VMS you can make such an alteration without so much as closing the database.
The lock manager serializes it just like any other change. Received on Sat Aug 27 2005 - 00:59:18 CDT