SQL Server Index

How to drop a SQL Server index?

This article is on how to drop a SQL Server index from an existing table on a given database. It can be a relational or a transactional database. For instance, learn here why you need an index optimization plan on databasejournal. How to drop a SQL Server index? To drop

SQL Server Views

How to delete a SQL Server view?

How to delete a SQL Server view from the database? How to drop a view? For a SQL developer it’s a good practice to have a clean database and remove the unused or useless code. Unlike the tables, the views can be deleted from the database using a simple T-SQL

SQL Server Tables

How to delete a SQL Server table?

How to delete a SQL Server table? How to drop a table without checking if the table exists? Assume the object is already in the database. How to delete a SQL Server table from the database with a query? Here is a SQL script to create a SQL Server table.

SQL Server Functions

How to manage a SQL Server function?

How to manage a SQL Server function? SQL Server user-defined functions are very useful when you start T-SQL development on SQL Server. You need to use them very often so you have to learn the right syntaxes and avoid errors. At the beginning it can be tricky and frustrating because