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
Why do you prefer to truncate instead of drop table command?
Home
Netezza
Why do you prefer to truncate instead of drop table command?
0
votes
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
Why do you prefer to truncate instead of drop table command?
netezza
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Feb 21, 2023
by
Robindeniel
Just empties data from the table, keeping table structure, and permission intact.
Related questions
+1
vote
Q: How do you check the rows in a table are equally distributed in all SPU’s or not?
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
spu
netezza
+1
vote
Q: How do you redistribute a table?
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
netezza
+1
vote
Q: What is the maximum number of columns you can choose as organizing keys for a clustered base table?
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
netezza
0
votes
Q: If you did not specify any distribution clause, how the Create Table AS (CTAS) will distribute the rows?
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
netezza
ctas
+1
vote
Q: Which system table could be used to find an object id for any table/view or object in a database?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
netezza
+1
vote
Q: Which one of the following pieces of information is maintained in the zone map table to assist the performance of a query?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
netezza
+1
vote
Q: What are the ways to load data from a table into a file?
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
netezza
table
0
votes
Q: Create Table AS (CTAS), does it distribute data randomly or based on the table on which it received data?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
netezza
ctas
0
votes
Q: What constraints on a table are enforced?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
netezza
0
votes
Q: When Netezza redistributes a table and when it broadcasts a table?
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
netezza
...