| Join Forum
Post New Query
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
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
Spring @ConfigurationProperties not working
Spring batch csv to db
sort numeric columns
Angular map vs filter
Angular map vs mergeMap
Angular 2 Radio Button and Checkbox Example
Angular 2 Http post() Example
Java 8 Stream sorted() Example
Angular 2/4 Pattern Validation Example
Angular 2/4 minlength and maxlength Validation Example
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.
©2019 concretepage.com |