How to Delete unwanted tables from a DB?(Contains keywords Temp/BKP/Backup/TMP)

preview_player
Показать описание
This Video Described that how to remove unwanted junk tables from particular database and we need to create a simple procedure for that
Here is the requirement
Create a new procedure
Input parameters
@Databasename --Db name is monditory
@schemaname---Schema name is not monditory
a)(If schema name is provided in the input parameter then we have to remove the objects which are depended under that schema)
If Not then
b)We have to clean all the tables for all the schemas(By Considering that key words)
Рекомендации по теме
Комментарии
Автор

Thanks for the video and nice explanation anna

UpendraYadav-teov