what is differnece between DROP TABLE & DELETE TABLE .
Answers were Sorted based on User's Feedback
in DROP TABLE command it will remove the table containts as
well as table structure from the database catalog, also it
release all the storage space it has acquired previously.
we can't rollback it as it is a ddl command.
but in case of DELETE TABLE command it just delete all the
records but not relaese the spaces it acquires .it can be
rollback as it is a dml command.
Is This Answer Correct ? | 17 Yes | 0 No |
Answer / durga prasad
drop table deletes the entire structure from the database
and it also removes entry from syscat.tables. but where as
delete table only deletes the rows in the table.
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / santy
DROP TABLe deletes the entire Structure of the TABLE from
the database with all the datas it contain, DELETE TABLE
deletes only the rows of the TABLE.
Is This Answer Correct ? | 7 Yes | 3 No |
Answer / siri
Drop : Drop table command it will remove table structure of the data base.....we can't rollback...
SYNTAX :- DROP TABLE TABLE-NAME..
DELETE : Delete table command it will delete rows from the table...for example i want delete empname in employee table i will write the query is.....
SYNTAX :- DELETE EMPNAME FROM EMPLOYEE
Is This Answer Correct ? | 1 Yes | 0 No |
Which is faster delete or truncate?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
What is DCLGEN ?
How does a cursor work?
What is db2 and what is the use of db2 optimizer?
What is the maximum No of rows per page?
In terms of DB2 indexing, what is the root page?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What is the difference between using bind () and rebind () methods of naming class?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?