Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 3 table and I want to delete or drop 3 field at a single line code from each table.
Is it possible ? If yes, Please suggest.
Regards,
K
Hi,
If they aren't in other tables you can just use
drop fields X,Y,Z;
if they are present elsewhere, you'd have to specify the table for each one.
Hi iTree,
you can try use
Drop Fields fiel1,field2,field3
If you use this command after the three tables, it will remove from all tables, if they are different fields, execute after the 'FROM' of each table
Suppose
I have :
Table 1 |
---|
A |
B |
C |
Table 2 |
---|
D |
E |
F |
Table 3 |
---|
G |
H |
I |
Now I want to delete by using single line code - From Table 1 -- A, Table 2 -- D, Table 3 -- G,
Not Multiple line of multi-line Drop statement.
Thanks for Reply. Any Idea please suggest.
After loading all these tables in the last line just do
Drop Fields A,D,G;
or
drop the fields A,B from Tabl1,Table2;
how to drop multiple field names like this 'David muffle' In the table