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 happens if an integer is too big for int date type?
Explain the third normal form(3nf)?
What is unique key constraint?
What is difference between inner join and join?
Explain timestamp datatype?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is sqlcmd?
What is indexing in sql server with example?
What are four major operators that can be used to combine conditions on a where clause?
Why olap is used?
What are the differences between DDL, DML and DCL in SQL?
Can we check locks in database? If so, how can we do this lock check?
Define Unique Key?
What are the different types of normalization?