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_at_newsread3.news.atl.earthlink.net>
Date: Sat, 27 Aug 2005 05:59:18 GMT
Message-ID: <WiTPe.2926$FW1.465_at_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 - 07:59:18 CEST