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

Question

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!

Answer 1

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.