Database schema change of result in query sql server

Kanav Sharma 0 Reputation points

How we can get database schema change result in query sql server? Is there any tool ? Suppose we do any change in schema. I want the result of that change in query.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,635 questions
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,462 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. PercyTang-MSFT 12,041 Reputation points Microsoft Vendor

    Hi @Kanav Sharma

    You can use the Schema Changes History report available in SQL Server Management Studio.

    To access this report, right click the database then from the context menu choose Reports -> Standard Reports -> Schema Changes History.

    You can refer to the previous thread.

    Best regards,

    Percy Tang

    0 comments No comments