Stored procedures for SQL Server

1.sp_databases lists all database information on the server, including the database name size.

Example: EXEC sp_databases

2.SP_HELPDB reports information about a specified database or all databases.

Cases:

EXEC sp_helpdb

3.sp_renamedb Changing the database name

Example: Exec sp_renamedb ' myschool ', ' Wode '

4.sp_tables returns information about a table or view that can be queried in the current environment.

Example: Exec sp_tables

5.sp_columns returns information about the columns of a table or view, including the data type and length.

Example: EXEC sp_columns Grade

6.sp_help View a Database object information.

Example: EXEC sp_help

7.sp_helpconstraint view constraints on a table.

Example: Exec sp_helpconstraint Grade

8.sp_helpindex View the index of a table.

Example: Exec sp_helpindex Grade

9.sp_stored_procedures displays a table of stored procedures.

10.sp_password Add or modify the password for the login account.

Stored procedures for SQL Server