View Designer Option

3 Apr 2006 11:48 AM

Cgal

Is there a way to set view attributes in the View Designer? This is a
awesome tool but it seems to fall short when specifying the options. For
example, if you want to create a view with the CHECK OPTION, can you do this
in the View Designer.

I found some options (such as SCHEMABINDING) in the properties window for
the view but that was it. Also, is there an option to script the View
instead of creating it directly from the View Designer.

Any help would be greatly appreciated.

Thanks!

4 Apr 2006 2:15 AM

privatenews

Hello,

Based on my scope, add check option is not available. After you create a
view, you could right click the view->Script view as->Alter to->New query
editor window, and you could edit the view as you want.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

>From: "Cgal" <cgallelli@newsgroups.nospam>
>Subject: View Designer Option
>Date: Mon, 3 Apr 2006 07:48:55 -0400
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <#sxlZSxVGHA.5***@TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.tools
>NNTP-Posting-Host: rrcs-24-97-2-84.nys.biz.rr.com 24.97.2.84
>Path:

TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP0
9.phx.gbl
Show quote

>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.tools:30185
>X-Tomcat-NG: microsoft.public.sqlserver.tools
>
>Is there a way to set view attributes in the View Designer? This is a
>awesome tool but it seems to fall short when specifying the options. For
>example, if you want to create a view with the CHECK OPTION, can you do
this
>in the View Designer.
>
>I found some options (such as SCHEMABINDING) in the properties window for
>the view but that was it. Also, is there an option to script the View
>instead of creating it directly from the View Designer.
>
>Any help would be greatly appreciated.
>
>Thanks!
>
>
>