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 is private mode? When does user switch to user mode?

1120


what is the difference b/w 4.6c & 4.7EE?

2210


What is an “ok” code is and what is the difference between “t-code” and “ok” code?

1210


hi friends, in sap screen with 000 client i unable to logon,with 001 client i can login but i want to log on with 000 client how i can loggin with 000 client intial screen ,please can u help me

6924


What are the different types of rfc?

1039


When we are doing cash sales, free goods and discount, How many pricing procedure do we need to create..? Only one PP required or have to create multiple PP..? and how many condition type we need to create..?

1228


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

1016


How do you solve oracle archive struck?

1859


What is an interface in SAP?

1193


What is the different type of users in sap?

1039


How you will rate yourself in SAP, Oracle from a scale 1 - 10?

2432


A user moved the transport request from dev to qua. How would you trace him?

1190


At os level how you can change the number of work process? How you can analyze the status of work process at os level?

1010


TMS Configuration?

1820


i want my company code and controlling area defaut as 'ABC" through out SAP what to do ? and my plantcode also default to some value

2021