1.
Execute sp_databases queries all current database approximate information (name, size, etc.)
2.
exec sp_helpdb [MySchool] Returns all the details of the database (database size, location, filegroup, owner, log size, location, etc.), displaying all database information without parameters
3.
exec sp_renamedb ' old_name ', ' new_name ' modifies the database name, the previous parameter is the old name, and the following parameter is the new name
4.
exec sp_tables [grade] View table information
5.
EXEC columns Table name view column information, must have table name parameter
6.
exec sp_help objname objname The name of an object of any user-defined data type in the sysobjects type or systypes table, and returns the result set as summary information for all types of objects.
7.
EXEC sp_helpconstraint Student--Query all constraints of the current table, must be located to the corresponding database
8.
EXEC sp_helpindex objname--Query the index of a user-defined table or view, objname a qualified or unqualified name for a user-defined table or view, you must navigate to the appropriate database
9.
EXEC sp_stored_procedures-Displays a list of stored procedures with default values, default NULL to display all stored procedures
10.
exec sp_password @old = ', @new = 1234--Change the password for the current login, @old default to NULL, @new No default value, you must specify
11.
EXEC sp_helptext Vw_studentinfo[usp_getscore]--Displays the actual text of a stored procedure that is not encrypted by default, or a user-defined view (vw_studentinfo), stored procedure (usp_getscore) or trigger actual text
SQL Server System stored procedures