insert single column

[Former Member]

Hi all.

What is the sql statement for insert a single column to the table?

Let say i gt a student table and a admino column.

Thank

[sreeramkumar_madisetty]

Hi

You have to create that column in table level (SE11) and you have to adjust that table after addtion using SE14.

Regards,

Sree

[h_senden2]

do not that kind of SQL statements in ABAP.

But use the data dictionary (transaction SE11) and add an additional field to the table.

regards,

Hans

[hymavathi_oruganti]

u can never insert a single column.

atleast u should insert blanks to the other fields.

inserting a row is possible , inserting single column will not be a normalised table.

by the way u can update a single column.

[Former Member]

I am not enough sure what you want exactly but you can try this...

update dbtab set f1 = <your value> [where <key fields to distinguish the unique row>].

It will update only the existing row.

regards

shiba dutta

[Former Member]

you cannot insert acolumn throgh SQL statement.

if u need to add a column u can do it only by getting on the table n adding a column to it's structure.

regards,

sohi