write down the code for "how we delete a table without
using of Drop command " ?
Answer Posted / shanmugam
truncate table tablename
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is store procedure? How do they work? When do you use?
how would you troubleshoot blocking? : Sql server database administration
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What are the different types of replication you can set up in sql server?
What is difference in performance between insert top (n) into table and using top with insert?
Define left outer join?
What is left outer join in sql server joins?
What is dbcc? Give few examples.
How do we Backup SQL Azure Data?
Is it possible to call a stored procedure within a stored procedure?
Explain various On-Delete options in a DB table. Which is the default option?
write an SQL query to list the employees who joined in the month of January?
Difference between report and query parameter.
What happens if null values are involved in datetime operations?
What is wide table?