Why truncate is ddl command?

Question Posted / amit srivastav

No Answer is Posted For this Question
Be the First to Post Answer

More SQL Server Interview Questions

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

How to use go command in "sqlcmd"?

Why I am getting this error when dropping a database in ms sql server?

What are the differences between stored procedure and functions in SQL Server 2000?

How will u get 5 years back record?

How to create a stored procedure with a statement block in ms sql server?

How can I check that whether automatic statistic update is enabled or not?

Explain cursor as data base object?

what is the disadvantage of SQL Loder?

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

Difference between connected and disconnected database in .net with sql server?

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

For more SQL Server Interview Questions Click Here