ZSBD 1

sysdatabases

master

Contains one row for each database on SQL Server

sysusers

Ali

W

Contains one row for each Windows 2000 user, Windows 2000 group, SQL Server user, or SQL Server role in a database

~fcIbM*, Uj)uic^s

sysobj ects

Ali

Contains one row for each object in a database

sp_help [object_name] Provides information on the specified database object

sp_helpdb [database_name] Provides information on the

specified

database

sp_spaceused [objname] Summarizes the storage space that a

database or

database object uses.

sp_helpfile [[Sfilename =]    'name'] Returns the physical names

and attributes of

files associated with the current database. Use this system stored procedurę to determine the names of files to attach to or detach from the server.

sp_helpfilegroup [filegroup_name] Returns the names and

attributes of filegroups

associated with the current database.

np. EXEC sp_help Employees

DB_ID

Name

Returns the database ID USER NAME

ID

Returns the user's name np. SELECT USER_NAME(10)

TMmDMBTmM ccuitme tscttc List of tables in the database

O