Answer / sruthi

Index created on view is called as indexed view or
materialised view.
To create index on a view we should create a view
with "schemabinding"
eg:
create view v1 with schemabinding as
select empno,ename from dbo.emp
---
while creating view with schema binding refer to table by
default owner
---
now create index on that view
--
create clustered index i1 on v1(empno)
--
now this is called as indexed view

Answer / manoj joshi

Creating index on views is not possible in Sybase.

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers  

---

What are the differences between stored procedure and the dynamic sql?

0 Answers  

---

what types of replication are supported in sql server? : Sql server database administration

0 Answers  

---

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  

---

---

Can a table be moved to different filegroup?

0 Answers  

---

What is data source in connection string?

0 Answers  

---

what is a mixed extent? : Sql server administration

0 Answers  

---

How is table type constraint applied to a table?

0 Answers  

---

What are .mdf files?

0 Answers  

---

define and explain the differences between clustered and non-clustered indexes.

0 Answers   Microsoft,

---

What is transact-sql language?

0 Answers  

---