Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Mike Gagnon
  Where is Mike Gagnon?
 Pointe Claire
 Canada
 Mike Gagnon
 To: Nadeem Shah
  Where is Nadeem Shah?
 Rawalpindi
 Pakistan
 Nadeem Shah
 Tags
Subject: RE: Remove Stru
Thread ID: 416257 Message ID: 416270 # Views: 52 # Ratings: 1
Version: Visual FoxPro 9 Category: VFP and .NET
Date: Thursday, December 25, 2014 1:24:14 PM         
   


> >
> > Please give me a example to use can this alter table drop
> >
> > Sandeep Singh (Ludhiana)
>
>
>
*add field
> ALTER table products ADD COLUMN sobook l DEFAULT .f.
> ALTER table billing ADD COLUMN  name c(30)
> 
> *drop field
> Alter Table products drop COLUMN sobookr
> Alter Table products drop COLUMN name
> 

>
> Nadeem Shah

 ALTER table products ADD COLUMN sobook l DEFAULT .f.
 Alter Table products drop COLUMN sobookr


This will most likely cause an error.

Mike Gagnon

ENTIRE THREAD

Remove Stru Posted by sandeep singh @ 12/25/2014 7:06:54 AM
RE: Remove Stru Posted by Jun Tangunan @ 12/25/2014 8:01:05 AM
RE: Remove Stru Posted by sandeep singh @ 12/25/2014 8:20:47 AM
RE: Remove Stru Posted by Nadeem Shah @ 12/25/2014 11:19:23 AM
RE: Remove Stru Posted by Mike Gagnon @ 12/25/2014 1:24:14 PM
RE: Remove Stru Posted by Nadeem Shah @ 12/25/2014 3:53:41 PM
RE: Remove Stru Posted by Mike Gagnon @ 12/26/2014 1:34:55 PM
RE: Remove Stru Posted by Nadeem Shah @ 12/26/2014 5:47:39 PM
RE: Remove Stru Posted by Tore Bleken @ 12/25/2014 12:38:42 PM
RE: Remove Stru Posted by Vivek Deodhar @ 12/26/2014 8:09:16 AM
RE: Remove Stru Posted by Manish Swami @ 12/25/2014 10:26:07 AM
RE: Remove Stru Posted by sandeep singh @ 12/31/2014 8:49:53 AM