YES, It drops all related objects, which exists INSIDE a table like, constraints, indexes, columns, defaults, etc. BUT dropping a table will not drop Views and Stored Procedures as they exist OUTSIDE the table
When SQL Server drops a table, it also deletes all data, triggers, constraints, permissions of that table.
Moreover, SQL Server does not explicitly drop the views and stored procedures that reference the dropped table.
Therefore, to explicitly drop these dependent objects, you must use the DROP VIEW and DROP PROCEDURE statement.
Answers ( 2 )
YES, It drops all related objects, which exists INSIDE a table like, constraints, indexes, columns, defaults, etc. BUT dropping a table will not drop Views and Stored Procedures as they exist OUTSIDE the table
When SQL Server drops a table, it also deletes all data, triggers, constraints, permissions of that table.
Moreover, SQL Server does not explicitly drop the views and stored procedures that reference the dropped table.
Therefore, to explicitly drop these dependent objects, you must use the DROP VIEW and DROP PROCEDURE statement.
Reference:
https://www.sqlservertutorial.net/sql-server-basics/sql-server-drop-table/