Monday, July 23, 2012

Restriction on Views in Microsoft SQL Server

Restrictions are applied when we create views in Microsoft SQL Server. These restrictions are listed below :

  1. Views created, only referencing tables and views in current database. 
  2. View name must not match with the name of table owned by that user.
  3. Views can be built based on other views and on procedures that reference views.
  4. We cannot associate Rules or DEFAULT definitions with views.
  5. We can only associate INSTEAD OF triggers with views.
  6. ORDER BY, COMPUTE, COMPUTE BY clauses and INTO keyword cannot be included in query that defines view.
  7. Full-text index definitions cannot be used for views.
  8. Temporary views cannot be created
  9. Views cannot be created on temporary tables.


6 comments:

  1. Thank you for posting such a useful, impressive and a wicked article.your background is so beautiful. you have give me great news.you have done great job please keep it up. your post is important and nice. Thanks for sharing with me.
    Web Application Development

    ReplyDelete
  2. Thanks for ones marvelous posting! I genuinely enjoyed reading it,you are a great author. I will be sure to bookmark your blog and may come back very soon
    diazepam purchase

    ReplyDelete
  3. HayCompras
    Nice post and right to the point. I am not sure if this is actually the best place to ask but do you folks have any ideea where to hire some professional writers? Thanks in advance 

    ReplyDelete
    Replies
    1. Its remarkable to pay a quick visit this web site and reading the views of all mates regarding this post, while I am also zealous of getting familiarity.
      resole climbing shoes

      Delete
  4. Productos hasta 85% de Descuento. Envío en 24-48h. Productos de Cocina, Electrónica y Electrodomésticos, Hogar, Perfumes y Cosmética, Regalos, Salud y Belleza, Fitness y Deportes
    Regalos

    ReplyDelete
  5. Buy 1 Million Facebook Fans
    This is a nice post in an interesting line of content.Thanks for sharing this article, great way of bring this topic to discussion.

    ReplyDelete