• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Views > Creating Views with SQL

Creating Views with SQL

The following code is the SQL command for creating a view. The query designer also uses this command internally.

CREATE VIEW view_name [ ( column [ ,...n ] ) ] 
[ WITH ENCRYPTION ] 
AS
select_statement
[ WITH CHECK OPTION ]


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint