SQL Server: drop table cascade equivalent?

by

In SQL Server Management Studio, go to Options / SQL Server Object Explorer / Scripting, and enable ‘Generate script for dependent objects’. Then right click the table, script > drop to > new query window and it will generate it for you.

More Related Contents:

  1. Copy tables from one database to another in SQL Server
  2. Saving changes after table edit in SQL Server Management Studio
  3. SQL Server 2005 – Export table programmatically (run a .sql file to rebuild it)
  4. Should I use the CASCADE DELETE rule? [duplicate]
  5. Get Parent with multiple children in desc order
  6. How can I schedule a job to run a SQL query daily?
  7. Convert Month Number to Month Name Function in SQL
  8. SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]
  9. Reset identity seed after deleting records in SQL Server
  10. How to avoid the “divide by zero” error in SQL?
  11. Multiple INSERT statements vs. single INSERT with multiple VALUES
  12. Limit on the WHERE col IN (…) condition
  13. Removing leading zeroes from a field in a SQL statement
  14. Get day of week in SQL Server 2005/2008
  15. Getting result of dynamic SQL into a variable for sql-server
  16. Better techniques for trimming leading zeros in SQL Server?
  17. Simple Query to Grab Max Value for each ID
  18. SQL Server: Extract Table Meta-Data (description, fields and their data types)
  19. SQL Server 2008: how do I grant privileges to a username?
  20. SQL GROUP BY CASE statement with aggregate function
  21. How can I include null values in a MIN or MAX?
  22. Favourite performance tuning tricks [closed]
  23. Best way to do nested case statement logic in SQL Server
  24. Query a database based on result of query from another database
  25. How to delete the top 1000 rows from a table using Sql Server 2008?
  26. CHECK CONSTRAINT on multiple columns
  27. Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
  28. SQL count consecutive days
  29. COALESCE Function in TSQL
  30. Can’t create stored procedure with table output parameter

Leave a Comment