how to create a view with schemabinding

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

how to create a view with schemabinding

Author

Topic

whitebird
Starting Member

12 Posts

Posted - 2008-02-28 : 05:56:21

hi,
my sql query is like this
create view table1 with schemabidning
as
select columnname from table1

but it is giving error msg like this
you cannot create view 'Cannot schema bind view'

please help me out how to create a view with binding to underlying table.

Raghu sunkara.

sunil
Constraint Violating Yak Guru

282 Posts

Posted - 2008-02-28 : 06:01:29

see if this link helps
http://www.sql-server-performance.com/faq/cannot_bind_schema_p1.aspxhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=95732

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-02-28 : 06:01:51

quote:
Originally posted by whitebird

hi,
my sql query is like this
create view table1 with schemabidning
as
select columnname from table1

but it is giving error msg like this
you cannot create view 'Cannot schema bind view'

please help me out how to create a view with binding to underlying table.

Raghu sunkara.

Whay are giving view same name as table? give it another name. Also there is typo in word schemabinding. Also try to use fully qulaified name for tables, i.e ownername.tablename

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources