How to delete a table from Database level.

Answer Posted / abhay sequeira

Pl. don't do that. Doing so would put the database at an
inconsitent state.

if your installation is under unix and the db is oraacle,
then login as the database administrator.
1) su - ora<SID>

2) sqlplus "/ as sysdba";

3) drop table <schemaname>.tablename;

You can only drop the table if you own it. There are many
such restrictions imposed so that the user does not
delete / drop any table inadvertently

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is XI3.0? Explain XI

971


Where do you download trail version of sap ecc, what is sap cal?

872


what are the current support stack levels at market place?

1990


What is the purpose of table tdevc?

2279


How do you create an instance?

845


Have you done any up gradations?

1968


Explain the system log?

852


What is MySAP?

873


How will go about doing a client copy ?

836


What is a developer key? and how to generate a developer key?

871


what post steps and pre steps db refresh

2931


How database extend?

1650


How should I set priority for Printing say like user, teamlead, project manager?

807


What is the system's configuration required to implement SAP.

1131


What is the purpose of tdevc ?

1173