The role of each system table in SQL Server

xiaoxiao2021-03-06  17

SysalTfiles master database saves database files

Syscharsets primary database character set and sort order

Sysconfigures Main Database Configuration Options

SyscurConfigs primary database Current configuration options

The database in the SysDatabases main database server

Syslanguages ​​Main Database Language

Syslogins master database login account information

Sysoledbusers master database link server login information

Sysprocesses primary database process

SysRemotelogins master database remote login account

Syscolumns Each Database Column

Sysconstrains each database restriction

Sysfilegroups Each database file group

Sysfiles Each database file

SysForeignKeys Each database exterior keyword

SysIndexs Each database index

Sysmenbers Each database role member

Sysobjects All database objects

Syspermissions Each database permission

SYSTYPES Define Data Types Each Database User

SYSUSERS Each database user

转载请注明原文地址:https://www.9cbs.com/read-45168.html

New Post(0)