I ma trying to create the view in sqlserver.
Create view v_test
select * from Test
When I run ,its throwing the error like Msg 15135, Level 16, State 8, Procedure sp_addextendedproperty, Line 37
Object is invalid. Extended properties are not permitted on 'dbo.v_test', or the object does not exist.
The statement has been terminated.
Can anyoone help me?
There are 2 possibilities for your problem
1. you may not have rights to create view
2. table may not be there in your table
Note: Your syntax is 100% correct.so verify the above 2 steps mention by me.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)