DQL Query

Options
Sanober
Sanober
edited February 7, 2017 in Documentum #1

Hi Experts,

How can we delete a value from Register Table.

Ex:-

delete from dm_dbo.junction where emp_id=20757

this query deletes the whole record of emp.i just want to delete his profile


i also tried this

delete emp_profile from dm_dbo.junction where emp_id=20757

but it returns error.


Tagged:

Comments

  • DCTM_Guru
    DCTM_Guru
    edited February 6, 2017 #2
    Options

    What do you mean "his profile"?  If you just want to clear the value of emp_id, but not delete the row, use an UPDATE

  • Sanober
    Sanober
    edited February 7, 2017 #3
    Options

    like

    update dm_dbo.junction set emp_profile=' ' where emp_id=20757

Categories