Post reply

create a view with schema binding

  • August 1, 2005 at 3:20 am

    #69497

    Hello everybody,                                              I want to create a view with the option 'schema binding'.What is the problem in my statement

    create view checks with schemabinding as select sno from test,

    I receive an error msg as,

    Cannot schema bind view 'checks' because name 'test' is invalid for schema binding. Names must be in two-part format and an object cannot reference itself.

  • August 1, 2005 at 4:26 am

    #578458

    You need to qualify the object with it's owner name.

    create view dbo.checks with schemabinding as select sno from dbo.test

    Should do it

  • August 8, 2005 at 3:01 am

    #580345

    Thanq mike, now only i saw ur reply n thans once again

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply