Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 are the key responsibilities of sap basis administrator?

1076


What do you understand by executing background jobs in sap system?

977


Can any one tell me some real time errors you got for support pack apply, During transport request export-import and for db dackup.

2612


can any send unix admin doc? if u have please send it to chanduk29@gmail.com

1969


What is purpose user group in SU01?

2947


I would like to know the version or name of SAP that is implemented in real time?

1139


Which are the most frequent errors encountered while dealing with transports ?

1283


Is there a difference between user ddic and sap_all/sap_new?

1597


does the Tcode EWZ5 exist in ECC6?I'm using NW2004S SR2 abap engine and EWZ5 doesn't exist in that.so in that case what is the alternative to EWZ5?to see the list of users present in a client but not necessarily logged in and to to lock or unlock them? Thanks.

3909


How to setup RFC connection in ecc6 tells me steps involved?

2119


what is role of sap administrator in pi & ep?

2448


What are the different options available for scheduling a background job? What start conditions type can be used?

1054


Is there a way to perform sapgui 640 roll out using a centralized server?

1129


How can I restrict the user from printing?

1086


What is XI3.0? Explain XI

1195