Write down the syntax and an example for create, rename and delete index?
Submitted by: AdministratorCreate 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
Submitted by: Administrator
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
Submitted by: Administrator
Read Online MS SQL Server Indexes Job Interview Questions And Answers
Top MS SQL Server Indexes Questions
☺ | Explain the types of indexes? |
☺ | Explain the purpose of indexes? |
☺ | Can you explain important index characteristics? |
☺ | Write down the syntax and an example for create, rename and delete index? |
☺ | Explain Having clause and Where clause? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |