View on GitHub

DP-080: Querying Data with Microsoft Transact-SQL

Companion material and resources for the course 'Endpoint Administrator' delivery by Ricardo Cabral

Back to main


SQL Standart

The first SQL standard was released by the American National Standards Institute (ANSI) in 1986. Is held by ANSI and the International Standards Organization (ISO) as the ISO/IEC 9075 standard.

SQL Schema

A schema is a collection of database objects.

Every object has a unique name.

Every object belongs to one schema.

So, each schema will have its own tables, views, relationships and other objects and for the user who accesses them they will be, in practice, like separate databases.

The following schemas cannot be dropped deleted because they are built-in logical schemas:


Back to main