[SQL] Ynt: where's ALTER TABLE table DROP [ COLUMN ] column???

Hi, I want to make a little correction. The correct syntax should be: SELECT [all columns except named] into mytemp1 from [$table_name] ; drop table [$table_name]; SELECT * into [$table_name] from mytemp1; With regards, Devrim GÜNDÜZ Keith Gray <[EMAIL PROTECTED]> wrote in message [EMAIL PROTE

[SQL] Ynt: corrupted tables !!!

Hi, What kind of a corruption? Do you lose data? As far as I tested; bas transactions do not destroy db. With regards, Devrim "J.Fernando Moyano" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > > I have big

[SQL] altering date type of a column

Hi, I have a table in one of my databases which has a row of type char. I would like to convert it to int data type. Is there an easy way for doing it? With regards, Devrim GÜNDÜZ [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you sear