what is the sp_help

Sudharsan K 0 Reputation points
2023-03-31T09:19:39.9666667+00:00

return in my computer is vary happy movement

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,142 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 45,291 Reputation points
    2023-03-31T09:26:08.71+00:00

    Your post is very unclear, but if you are looking for sp_help, as in post subject, see

    https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-help-transact-sql?view=sql-server-ver16

    0 comments No comments

  2. RahulRandive 9,901 Reputation points
    2023-04-02T15:21:22.4033333+00:00

    The main use of sp_help is to quickly retrieve metadata information about a database object in SQL Server.

    sp_help is a system stored procedure in Microsoft SQL Server that can be used to retrieve information about a database object, such as a table, view, stored procedure, or user-defined function.

    The sp_help procedure can be useful for database administrators, developers, and users who need to retrieve information about the database objects they are working with

    When executed with the name of a database object as a parameter, sp_help returns a result set that provides detailed information about the object's structure and properties, such as its column names, data types, constraints, indexes, and triggers.

    Thank you!

    0 comments No comments

  3. PercyTang-MSFT 12,501 Reputation points Microsoft Vendor
    2023-04-03T01:42:12.9266667+00:00

    Hi @Sudharsan K

    In addition to the above two answers, you can also refer to this link, which provides some brief introductions and examples.

    https://sqlserverplanet.com/dba/using-sp_help

    Best regards,

    Percy Tang


    If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.