Managing your RDBMS' Extended Properties has never been easier. You can now Add/Edit, or Manage a new schema extended property directly inside of Schema Explorer.
...
To manage your Extended Properties, simply open up the Schema Explorer window. You can open Schema Explorer by selecting the Schema Explorer menu item under the View menu in the Template Editor or Generator menu in Visual Studio.
| Info |
|---|
| Schema Explorer has been modeled after SQL Management Studio's Object Explorer. This proven design makes it very easy to navigate and configure schema objects (E.G., Tables, Views, Commands). |
...
Some Extended Properties may already be defined and listed in the Extended Property Editor. These Extended Properties normally start with "CS_" and "MS_", and are managed by the underlying Schema Provider. T
Finally, we will add a new Extended Property by typing an Extended Property Name in the first empty row. Please note that the row will always be at the bottom of the list and a * will be shown in first column. Next, you will need to specify a datatype of the extended property and value. Please see the section below for saving Extended Properties.
...
| Warning |
|---|
All Extended Properties are managed by the Schema Provider you are using. If a Schema Provider does not support Extended Properties then an a NotSupportedException will be thrown when adding, removing, deleting or saving an Extended Property. |
...
| Info |
|---|
Extended Properties beginning with "CS_" and "MS_" may be read-only. Read-only Extended Properties cannot be removed or modified. |
| Info |
|---|
| If you are updating the CS_Description Extended Property when using SQL Server, then the MS_Description Extended Property will be updated. This is because the CS_Description is an alias to the MS_Description. |
...
- Start by right-clicking on a row and select selecting the Delete menu item.
- Click on the row selector (first row) and press the Delete key.
...