Set column as unique in SQL Server from the Management Studio

By -

 Set column as unique in SQL Server from the Management Studio

1. Open SQL Server Management Studio.
2. Right click your Table, click "Design".
3. Right click the column you want to edit, a popup menu appears, choose "Indexes/Keys".
4. Click the "Add" Button.
5. Expand the "General" tab.
6. Choose the Columns to make unique selected in the "columns" box.
7. Change "Is Unique" to "Yes".
8. Click "Close".
9. Save the Database.

 

Reference:  https://stackoverflow.com/questions/5181877/how-can-i-create-a-unique-constraint-on-my-column-sql-server-2008-r2

Comments

Post a Comment

Popular posts from this blog

Google: How to disable Auto Licensing

By -
Image
  How to disable Auto Licensing   Problem You are not able to turn off Auto Licensing in the Admin console. Environment Admin console Solution Log in to the   Admin console . Select  Billing   >   Subscriptions   >   Add or upgrade a subscription . Select  Cloud subscriptions   and enable   Cloud Identity free . Go back to the main   Subscriptions   page and select the Google Workspace edition. Click   License settings  and then turn off   Auto Licensing . Cause Auto Licensing cannot be disabled because there's only 1 subscription active in the Admin console.         Reference: https://knowledge.workspace.google.com/kb/how-to-disable-auto-licensing-000005702#problem  How to manage automatic licensing settings   Problem How to modify auto licensing in a way whenever there is an attempt to create a new user it is possible to choose which subscription that user sho...
Read more

Microsoft 365で多要素認証の設定を解除したい

By -
Image
  Microsoft 365で多要素認証の設定を解除したい   保護」＞「認証方法」＞「設定」＞「システムが優先する多要素認証」で「状態」を「無効」にして保存       「ID」＞「概要」＞「プロパティ」＞「セキュリティの既定値群」で「セキュリティの既定値の管理」をクリックすると右側にその項目が表示されるので、「セキュリティの既定値群」を「無効」に設定     Reference: https://too-support.my.site.com/faq/s/article/000003294
Read more