Shulou(Shulou.com)06/01 Report--

Editor to share with you what are the sql server system tables, I hope you have something to gain after reading this article, let's discuss it together!

SQL system table

The sysaltfiles master database holds the files of the database

Character set and sort order of syscharsets main database

Sysconfigures master database configuration options

Current configuration options for the syscurconfigs primary database

Databases in the sysdatabases master database server

Syslanguages master database language

Login account information of syslogins main database

Sysoledbusers main database link server login information

Sysprocesses master database process

Remote login account for sysremotelogins master database

Syscolumns each database column

Sysconstrains per database limit

Sysfilegroups each database filegroup

Sysfiles each database file

Sysforeignkeys each database external keyword

Sysindexs each database index

Sysmenbers each member of the database role

Sysobjects all database objects per database

Syspermissions permissions per database

Systypes per database user-defined data type

Sysusers every database user

After reading this article, I believe you have a certain understanding of "what are the sql server system tables". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.