Analysis of master database in SQL Server

server|sqlserver| Data | database

Table sysdatabases: Saving database information in a DBMS
Select [Name] from [sysdatabases] ORDER by [name]
You can get the database information in the DBMS.

Table sysobjects: Saving data table information in a database
Con. ChangeDatabase (dbname)
SELECT [Id],[name] from [sysobjects] where [type]= ' u ', con
You can get table information for that database.

Table syscolumns: Saving column information for a datasheet
Select [Name] from [syscolumns] where [id]=] gets the ID of the table from sysobjects
You can get the column information for that table.