To delete all the rows in a table, use TRUNCATE TABLE. TRUNCATE TABLE is faster than DELETE and uses fewer system and transaction log resources. TRUNCATE TABLE has restrictions, for example, the table ...

Remove all references to the object in the SQL Pane. When you remove a table or table-valued object, the Query and View Designer automatically removes joins that involve that table or table-valued ...