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...

what is the syntax of DROP command?

Answer Posted / ruchika jena

If u want to drop a table then the command is

drop table <table_name>;

If u want to drop a column_name then the command is

alter table <table_name> drop column <column_name>;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bulk load in oracle?

1070


List the types of joins used in writing subqueries?

997


Who developed oracle & when?

1003


What is oracle open database communication (odbc)?

1028


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1989


How to connect to a remote server?

1125


How to select some columns from a table in oracle?

1093


Explain integrity constraints?

1104


How to load data through external tables?

1135


What are the logical operations?

1125


Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2970


How to delete a column in an existing table?

1076


How to add a new column to an existing table with a default value?

1016


What is the quickest way to fetch the data from a table?

1058


How many types of synonyms in Oracle?

1124