how do you use a schema in sql server?

As you said, USE statement is not supported in Azure database. But it really means that we can not access another database resource by USE statement. For example, we can run the command in current database successfully: enter image description here

In Azure SQL database, each user(include the server admin account) has the default schema [dbo], if you didn’t specify it to other schema. When we create the table, it will automatically placed in the default schema.

Please see here: enter image description here

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top