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

Answer Posted / venkat

sp_rename

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are click through reports?

108


Differentiate between a local and a global temporary table?

631


What is the boxing and unboxing concept in .net?

634


What does sql server mean?

612


What are basics of policy management?

724






How to check status of stored procedure in sql server?

547


What are difference between Cluster index and Non-Cluster index?

683


How to list all stored procedures in the current database using ms sql server?

721


What is a partitioned view?

678


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1873


What are the differences between stored procedure and view in sql server?

716


If you want to send some data from access database to sql server database. What are different component of ssis will you use?

576


Explain the use of keyword with encryption. Create a store procedure with encryption?

629


How to rename an existing column with sql server management studio?

598


Name few endpoints exposed by ssrs 2012?

321