-- drop all user defined tables
EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"
-
Remove all Tables from database
-- drop all user defined tables
Subscribe to:
Post Comments
(
Atom
)
![](http://pinterest.com/pin/create/button/?url=https://javedakhtaransari.blogspot.com/2021/01/remove-all-tables-from-database.html&media=https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgR5D94jNPDSWhPcVPqLiVWqbjrux0ubemKjmPOfVBQipE21g9Z5dbfwBQXHZFno8SYPgfDeDOI5irGb77vkY1tesxrK5pylMbnw_bD2eWFtsyh6mqrakkLCdwQ6iuI0xv5xQHY-uLSIo0/s72-c/sql.jpg&description=Â -- drop all user defined tables EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"Â ){kind=link}
No comments :
Post a Comment