Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Returns one row for each schema in the current database. To retrieve information from these views, specify the fully qualified name of **INFORMATION_SCHEMA.**view_name. To retrieve information about all databases in an instance of SQL Server, query the sys.databases (Transact-SQL) catalog view.
Column name |
Data type |
Description |
|---|---|---|
CATALOG_NAME |
sysname |
Name of current database |
SCHEMA_NAME |
nvarchar(128) |
Returns the name of the schema. |
SCHEMA_OWNER |
nvarchar(128) |
Schema owner name. Important Do not use INFORMATION_SCHEMA views to determine the schema of an object. The only reliable way to find the schema of an object is to query the sys.objects catalog view. |
DEFAULT_CHARACTER_SET_CATALOG |
varchar(6) |
Always returns NULL. |
DEFAULT_CHARACTER_SET_SCHEMA |
varchar(3) |
Always returns NULL. |
DEFAULT_CHARACTER_SET_NAME |
sysname |
Returns the name of the default character set. |