write down the code for "how we delete a table without using of Drop comm

Categories >> Software >> Databases >> SQL Server
Suggest New Category

write down the code for "how we delete a table without
using of Drop command " ?

Question Posted / bandabia

7 Answers
11011 Views
CarrizalSoft Technologies, Sonata, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write down the code for "how we delete a table without using of Drop command " ?..

Answer / bhagwat sharma

table delete only by
drop table (tablename)

if you want do delete all data from table than you wil use
command

truncate table (tablename)

this command don't delete table delete only table data ok

Is This Answer Correct ?

16 Yes

1 No

write down the code for "how we delete a table without using of Drop command " ?..

Answer / shanmugam

truncate table tablename

Is This Answer Correct ?

7 Yes

3 No

write down the code for "how we delete a table without using of Drop command " ?..

Answer / sachin tendulkar

Can not be deleted without using DROP key word.

Is This Answer Correct ?

5 Yes

1 No

write down the code for "how we delete a table without using of Drop command " ?..

Answer / krishna

without using drop command u cant delete table .truncate is
only for delete the data parminently with out commit.where
as delete only for records deleting with commit
statement.once u commit for delete stmt it cant rollback.

Is This Answer Correct ?

4 Yes

1 No

write down the code for "how we delete a table without using of Drop command " ?..

Answer / venkat

sp_rename

Is This Answer Correct ?

3 Yes

2 No

write down the code for "how we delete a table without using of Drop command " ?..

Answer / jansi

delete from tablename

Is This Answer Correct ?

1 Yes

12 No

write down the code for "how we delete a table without using of Drop command " ?..

Answer / bru medishetty

DELETE FROM TABLENAME

Is This Answer Correct ?

7 Yes

20 No

Post New Answer