Thanks again for taking the time to reply, I selected the database that is using Always Encrypted and ran the following command
select * from sys.asymetric_keys
However, I received the following error message
Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.tde_keys'.
I can see under
Database (e.g. MyDataseName) > Security > Always Encrypted Keys > Column Master Keys
a key called CMK_Auto1
Database (e.g. MyDataseName) > Security > Always Encrypted Keys > Column Encryption Keys
a key called CEK_Auto1
However right-clicking and looking at the properties of these keys does not tell me where they are stored (locally or Azure Key Vault), unless I am missing something, hence reaching out to this forum
Perhaps there is a different query that can be run?