The role of each system table in SQL Server

Source: Internet
Author: User
Tags character set sql
Server sysaltfiles     main database               Save database files Syscharsets &nbs P   Main database               Character Set and sort order sysconfigures   main database    & nbsp          configuration options syscurconfigs   main database               Current configuration options sysdatabases   main database               Database in server syslanguages   main database               language syslogins    & nbsp Main database               login account information sysoledbusers   main database               Link Server login information sysprocesses   main database            & nbsp;  process sysremotelogins Main database               remote login account syscolumns   & nbsp Each database            &nbsp column sysconstrains   per database              sysfilegroups   per database              file group sysfiles        per database               file Sysforeignkeys per database              external keywords Sysindexs & nbsp    each database              Index sysmenbers     per database    &nbs P         Role member sysobjects     per database              All database objects syspermissions per database              permissions systypes        Per database              User defined data type sysusers        every database               Users

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.