Skip to content

Instantly share code, notes, and snippets.

@MarkPryceMaherMSFT
Created March 12, 2018 19:50
Show Gist options
  • Save MarkPryceMaherMSFT/30f2f3af5b19b5786daa5acdda7411f4 to your computer and use it in GitHub Desktop.
Save MarkPryceMaherMSFT/30f2f3af5b19b5786daa5acdda7411f4 to your computer and use it in GitHub Desktop.
Script for updating Extented Properties
exec sp_updateextendedproperty @name=N'sys_sensitivity_label_name', @level0type=N'schema', @level0name=N'Sales',
@level1type=N'table', @level1name=N'CustomerTransactions', @level2type=N'column',
@level2name=N'AmountExcludingTax',@value=N'Confidential'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment