SQL Server Performance Forum – Threads Archive

Drop table

Hi there,
I need to drop a table on the production server. The table has 15,000,000 records. Will it impact on the performance of the database while dropping the table? are there other things I should worry about? Many Thanks Dipendra

No there will not be any impact, but still to be on safer side better to use TRUNCATE TABLE and then drop the table with DROP TABLE statement. If you delete all rows in a table (DELETE tablename) or use the TRUNCATE TABLE statement, the table exists until it is dropped. BOL refers DROP TABLE cannot be used to drop a table referenced by a FOREIGN KEY constraint. The referencing FOREIGN KEY constraint or the referencing table must first be dropped. vA table owner can drop a table in any database. When a table is dropped, rules or defaults on it lose their binding, and any constraints or triggers associated with it are automatically dropped. If you re-create a table, you must rebind the appropriate rules and defaults, re-create any triggers, and add all necessary constraints.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>