Can you explain the use of sys.sp_addextendedproperty in the following code?

sql-server tsql sql-server-2008 extended-properties

Solution 1:

It looks like you used the GUI designer to create the view. In order to save the graphical layout of your tables in the designer, it's storing this metadata as an extended property. It doesn't affect how the view is actually processed. It's just so that you can run the designer again and have it look the way you left it.

Related

Checking if float is an integer
Get ID of element that called a function
Declare a reference and initialize later?
CSS image max-width set to original image size?
window not defined error when using extract-text-webpack-plugin React
When to use --hostname in docker?
A library to convert ANSI escapes (terminal formatting/color codes) to HTML [closed]
Equivalent to C#'s "using" keyword in powershell?
How to handle a SIGTERM
Where you can and cannot declare new variables in C?
Good way to get *any* value from a Java Set?
AngularJS - How can I create a new, isolated scope programmatically?