In Azure Data Studio:
I created a schema with "Create Schema test";
I created a table in that schema and populated it.
I ran a select statement to view this data successfully.
I attempted to create a Stored Procedure but received an error stating the table/schema could not be found.
I ran the same SP creation statement and it was successful.
The DB I am working with is unmanaged Azure SQL.
What am doing wrong in Azure SQL Studio?