Sql server - Syntax and an example for create, rename and delete index

Syntax and an example for create, rename and delete index.

Create Index:
CREATE INDEX index_name ON table_name (col_1,col_2..);
Example:
Create index index_sample ON employee(emp_id)
Rename Index:
ALTER INDEX index_name RENAME to new_index_name ;
Example:
ALTER INDEX index_sample RENAME to new_sample
Delete index:
drop index [schema.]index [force];
Example:
Drop index new_sample
What is a join and explain different types of joins
Joins are used in queries to explain how different tables are related........
What is a self join in SQL Server?
Two instances of the same table will be joined in the query...
Sql server - Explain the various types of concurrency problem.
Types of concurrency problem:- Lost or buried updates: - When the same row is selected for updates by two or more transactions and updates the row based on the value originally selected.........
Post your comment

Related Content

Follow us

▲