topic Re: insert single column in Application Development and Automation Discussions

insert single column

Former Member — Wed, 17 Oct 2007 06:47:56 GMT

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 — Wed, 17 Oct 2007 06:50:43 GMT

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 — Wed, 17 Oct 2007 06:51:21 GMT

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 — Wed, 17 Oct 2007 06:52:30 GMT

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 — Wed, 17 Oct 2007 06:55:42 GMT

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 — Wed, 17 Oct 2007 07:01:58 GMT

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