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

Answer Posted / jansi

delete from tablename

Is This Answer Correct ?    1 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is isolation level at dead lock?

1836


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1661


What are the types of subscriptions in SQL Server replication?

629


what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

677


What are data driven subscriptions?

85






Is sql server difficult to learn?

595


in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

640


What is 2nf in normalization?

618


How to get a list of columns using the "sys.columns" view in ms sql server?

642


What are the basic features of a trigger in ms sql server?

667


Explain about Views?

679


What is 1nf 2nf?

653


What specific conditions database should meet, before you can bulk copy data into it using bcp?

636


What is difference between stored procedure and user defined function?

633


What is difference between count (*) and count 1?

586