Skip to content
Sunday, September 24, 2023

Ramblings of a Crafty DBA

  • Home
  • About John

Tag: WITH VIEW_METADATA

User Defined Views – Part 3

January 8, 2013May 25, 2013 admin

Today, I want to continue talking about database objects that are associated with stored (compiled) code. A view can be though as a virtual table whose contents are defined by a TSQL query based on one or more tables in the database.   Typical uses of a view are the following: To simplify or customize the perception each user has of the database. Security mechanism to grant users access to the view, not the underlying base tables. To provide a backward compatible interface to emulate a table whose schema has…

Database DeveloperALTER VIEW, create view, database developer, DROP VIEW, free code, John F. Miner III, Schema Abstraction, sp_helptext, sp_refreshview, sp_rename, SQL API, SQL Server, TSQL, USER DEFINED VIEW, WITH CHECK OPTION, WITH ENCRYPTION, WITH SCHEMABINDING, WITH VIEW_METADATALeave a comment

Search Site

Categories

  • Database Admin (43)
  • Database Developer (81)
  • Integration Services (5)
  • Other (15)
  • Perl Scripting (7)
  • Power BI (4)
  • PowerShell (2)
  • Presentations (66)
  • SQL Tidbits (101)
  • VB Script (10)

Archives

Calendar

September 2023
M T W T F S S
 123
45678910
11121314151617
18192021222324
252627282930  
« Jun    

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Crafty Dba © 2016

Proudly powered by WordPress | Theme: AcmeBlog by Acme Themes