Database schema change of result in query sql server

Kanav Sharma 0 Reputation points
2023-11-16T22:31:07.1766667+00:00

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
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,462 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PercyTang-MSFT 12,041 Reputation points Microsoft Vendor
    2023-11-20T06:47:31.6666667+00:00

    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.

    https://learn.microsoft.com/en-us/answers/questions/1104823/can-we-get-the-table-schema-changes-from-sql-serve

    Best regards,

    Percy Tang

    0 comments