Skip to Content
avatar image
Former Member

Dictionary Perspective

in dictionary Perspective of java dictionary

i want to delete the table eg :<b>TBL_STUDENT</b>

I clicked on <b>delete table</b>

it appear to be <b>TBL_STUDENT (deleted)</b>

the item still there

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Jun 13, 2007 at 05:07 AM

    Hi,

    When you delete a table from dictionary explorer,it is marked as deleted and you cannot edit the table further as it is meaningless,however the corresponding xlf files are not deleted.

    This information is necessary for deployment so make sure you have deployed the deletion on your database and then delete the xlf files manually to avoid inconsistencies with the database.

    Regards,

    Vidya

    Add comment
    10|10000 characters needed characters exceeded

  • May 15, 2007 at 08:11 AM

    If you have already deployed your project then you have to remove that table from server too by logging in there.....

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 15, 2007 at 08:27 AM

    Hai,

    To delete the table from Source, just switch to navigator perspective, expand the dictionary project,>src>Projects , delete tableName.dtdbtable,tableName.xlf.

    SSwitch to dictionary perspective Reload+Rebuild the project. The table will delete from the source.

    Regards,

    Naga

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 13, 2007 at 05:53 AM

    Hi yzme,

    If u had Deployed the Dictionary project once, before deleting it, then the table gets created on the Java Schema on the WAS Database backend.

    As Vidya said, When you delete the TABLE in the Dictionary Project it is marked for deletion, and you are not allowed to change it further. But the Table is not Dropped from the backend... i.e from the database. to DROP the Table, u will need to explicitly Execute the DROP TABLE Command at the Database level of the WAS.

    Regards,

    Alka.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 13, 2007 at 06:05 AM

    Hi ..

    Just delete the TBL_STUDENT.dtdbtable and TBL_STUDENT.dtdbtable.xlf files from src in the navigator view.

    Regards,

    Arun

    Add comment
    10|10000 characters needed characters exceeded