sql plus-- how to drop all the tables at a time in a data base systems
Asked on October 07, 2013
how to drop all the tables from the server
Replied on October 09, 2013
Dropping all tables all together in database can be possible by two ways.
1. Suppose we a schema and tables are t1, t2 and t3.
drop it like
drop table t1, t2, t3
2. Second approach is to delete the schema and re - create it.
The syntax of deleting schema is
drop database test;
Replied on October 10, 2013
Second option is better.
Login | Sign Up
Set MySQL PATH in macOS
Start/Stop/Uninstall MySQL on macOS without Terminal
Delete Table in MongoDB
How to show table data in MongoDB
How to create user and password in MongoDB
How to create database in MongoDB
command to check primary key in oracle using query
java.sql.SQLSyntaxErrorException: ORA-01950: no privileges on tablespace 'USERS'
Difference between SQLite and MS Access
Define ACID Database Properties
java.sql.SQLException: Invalid column index
java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
java.sql.SQLSyntaxErrorException: ORA-00928: missing SELECT keyword
How to find minimum cover for any set in DBMS?
What are set of FDs for the relation in DBMS?
Can anyone help me in DBMS? I am not able to understand what the question mean?
Neo4j Cypher Query: How to fetch graph related to entity?
How to reset AUTO Increment in MySQL
find second max salary in SQL
Query/command to select second max value in a list using sql
Example of DBMS? Which is used in present industry?
Spring +Hibernate integration db connection using hibernate.properties
command to clear screen in oracle sql plus
What is the Database and what is the actual need of Database?
Latest Forum Post
Unlabeled ordinal parameter ('?' rather than ?1)
Angular FormGroup vs FormArray
Angular FormGroup vs FormBuilder
Angular FormControl vs ngModel
Angular FormControl dirty vs touched
We are a group of software developers.
We enjoy learning and sharing technologies.
To improve the site's content,
your valuable suggestions
are most welcome.
©2023 concretepage.com |