T-SQL
Drop a SQL Server View
How to drop a SQL Server view with a T-SQL query? The DROP VIEW command allows you to simply delete an existing view with a T-SQL script run from SQL Server Management Studio (SSMS). The script below is an …
drop
T-SQL
Manage SQL Server user defined functions
How to manage SQL Server user defined functions ? SQL Server user-defined functions are very useful when starting T-SQL development. You need to use them very often so you have to learn the right syntaxes and avoid errors. At …
SQL Server DBA
Drop a SQL Server database with a script
How to delete a SQL Server database with a script? And delete all associated files? These files are the .mdf, .ndf, .ldf files and also the .bak backup files. Use the SQL Server Drop database command as below. With …
