Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 7)
7.
The command to eliminate a table from a database is:
Discussion:
10 comments Page 1 of 1.
Nicat said:
9 years ago
Truncate is used for Emptying the interior.(Clear records from table). Example we have students table. If we use the truncate command, only deleted records, not column names.
Parvez said:
10 years ago
Truncate command clear the records and free the memory. Wheres delete command doesn't free the memory.
Santosh Yepuri said:
1 decade ago
Delete Command Can delete specific record but in Truncate command it is not possible to delete specific record. And in Truncate command Where clause not support.
Lovesh said:
1 decade ago
Truncate command is used to delete the complete data from an existing table.
syntax:
TRUNCATE TABLE table_name;
syntax:
TRUNCATE TABLE table_name;
Snehal said:
1 decade ago
What is use of truncate command?can we undo delete and truncate command?And difference between delete and truncate command?
Snehal said:
1 decade ago
Then what is use of truncate command and what is difference between delete and truncate command?
Can we undo these commands?
Can we undo these commands?
Vishwa said:
1 decade ago
But we can delete table from database by using Delete Command.
So Both B and C correct.
So Both B and C correct.
Manche Shekhar said:
1 decade ago
If you want to remove a table from the database then we use drop command.
Drop is a DDL command.
The syntax is:
Drop table <tablename>;
From oracle 10g onwards if u remove a table ,we can get back by using Flashback command:
The syntax is:
Flashback table <tablename> before drop;
If you want to remove a table perminently then we use purge command.
Drop table <tablename> purge;
Drop is a DDL command.
The syntax is:
Drop table <tablename>;
From oracle 10g onwards if u remove a table ,we can get back by using Flashback command:
The syntax is:
Flashback table <tablename> before drop;
If you want to remove a table perminently then we use purge command.
Drop table <tablename> purge;
Ruthvik said:
1 decade ago
Flash back is a command that is added from oracle 10g only, if we drop a table on oracle 8i or 9i we can't get it back.
Vinod said:
1 decade ago
Once the table is dropped from data base by using drop
the data will be exists in recycle bin ....
so we can get it back by using >flashback ....... command
if we drop the table by using
>drop table customer purge;
(drop+purge) the whole data will be loss from recycle bin so we will no get it back ..... even by using >flashback ...... command also
the data will be exists in recycle bin ....
so we can get it back by using >flashback ....... command
if we drop the table by using
>drop table customer purge;
(drop+purge) the whole data will be loss from recycle bin so we will no get it back ..... even by using >flashback ...... command also
(1)
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers