Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
An SQL query to delete a table from the database and memory while keeping the structure of the table intact?
Home
Sql
An SQL query to delete a table from the database and memory while keeping the structure of the...
0
votes
asked
Dec 15, 2020
in
Sql
by
SakshiSharma
An SQL query to delete a table from the database and memory while keeping the structure of the table intact?
DROP TABLE table_name;
DROP FROM TABLE table_name;
DELETE FROM TABLE table_name;
TRUNCATE TABLE table_name;
#sql-delete
#delete-database
Please
log in
or
register
to answer this question.
0
Answers
Related questions
0
votes
Q: Difference between TRUNCATE, DELETE and DROP commands in SQL?
asked
Jul 10, 2020
in
Sql
by
SakshiSharma
#sql-truncate
sql-drop-
#sql-delete
0
votes
Q: What is the difference between DELETE and TRUNCATE?
asked
Jul 7, 2020
in
Sql
by
Robindeniel
#sql-delete
#sql-truncate
#sql-delete-vs-truncate
#truncate-vs-delete
0
votes
Q: Write the SQL query to get the third maximum salary of an employee from a table named employees.
asked
Nov 8, 2021
in
Sql
by
rajeshsharma
sql-query
+1
vote
Q: Write a SQL SELECT query that only returns each name only once from a table?
asked
Jul 10, 2020
in
Sql
by
SakshiSharma
#sql-select
#select-sql
0
votes
Q: Query to insert SQL carriage return and line break in query? Below query will helps you to insert carriage return or line break while working with the string data.
asked
May 22, 2022
in
Sql
by
AdilsonLima
sql--lite
0
votes
Q: How to delete a table in SQL Server?
asked
Jun 12, 2023
in
Sql
by
Robin
sqlserver
tabledelete
0
votes
Q: How will you resolve an out of memory error while running a JOIN query?
asked
Jan 12, 2020
in
Big Data | Hadoop
by
sharadyadav1986
#hive-join
Bigdata-questions-answers
Hadoop-questions-answers
0
votes
Q: Which of the following holds data retrieved from a database after you execute an SQL query using Statement objects?
asked
May 21, 2020
in
JAVA
by
GeorgeBell
#java
Java-questions-answers
+1
vote
Q: Why do we use SQL constraints? Which constraints we can use while creating a database in SQL?
asked
Nov 26, 2020
in
Sql
by
SakshiSharma
#sql-constraints
#create-database-sql
+1
vote
Q: Why do we use SQL constraints? Which constraints we can use while creating a database in SQL?
asked
Jul 6, 2020
in
Sql
by
Robindeniel
#sql-constraints
#constraints-sql
#sql-database
...