Results 1 to 2 of 2
  1. #1
    adnancanada is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2010
    Posts
    121

    view on view

    I am using SQL server 2005. I have tons of view which I am using as virtual tables. I want to create index on view. I tried to run it. got error msg. Please note that my both views are POH and POD


    Cannot schema bind view 'vwakview'. 'dbo.POD' is not schema bound.




    create view vwakview
    with schemabinding
    as
    SELECT POH.AEDAT, POH.LIFNR, POD.PO, POH.TERM1, POH.TERM2, POD.DC, POD.SITE, POD.QTY, POD.WEIGHT, POD.VOLUM
    from dbo.POD
    INNER JOIN dbo.POH
    ON
    (dbo.POH.MANDT = dbo.POD.MANDT AND dbo.POD.PO= dbo.POH.PO)
    Last edited by adnancanada; 03-03-2017 at 08:34 AM.

  2. #2
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    http://stackoverflow.com/questions/3...t-schema-bound
    In order to create an indexed view the view needs to be schema bound to the entities that it is a view over.
    To make a view schema bound, simply specify simply use WITH SCHEMABINDING in the view CREATE / UPDATE query, for example:
    CREATEVIEW MyView
    WITH SCHEMABINDING
    AS
    -- SELECT

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 03-05-2015, 01:10 PM
  2. Replies: 6
    Last Post: 05-09-2014, 09:03 AM
  3. Replies: 2
    Last Post: 03-09-2014, 03:21 PM
  4. Replies: 5
    Last Post: 12-03-2013, 01:25 PM
  5. Replies: 8
    Last Post: 04-29-2013, 11:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums