Object reference not set to an instance of an object (AZURE SQL DB)

Rudolph Juillan Relucio 46 Reputation points

Good day!

I'd like to know how else can I access the Design tab in Azure SQL DB? Or how can I assign a column as a Primary Key? The column belongs to a migrated data from MS Access btw. Thank you!

Azure SQL Database
{count} votes

Accepted answer
  1. Anurag Sharma 17,386 Reputation points

    Hi @Rudolph Juillan Relucio , welcome to Microsoft Q&A forum.

    You can add the primary key to existing table using below script:

    ALTER TABLE <table name>ADD PRIMARY KEY (<column name>);  

    You can run this script from SSMS, Azure Data Studio or directly in the Azure Portal.

    Please let us know if you need any more assistance on this and we will be happy to assist you.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful