How to check database schema version

kulmam92kulmam92 Posts: 12
Hi

When using sql source control and svn to manage DB schema, is there a way to check which version of db schema that a database has? I'm asking if there's any version table or version information stored in the database, so that I can check the schema version without using source control tool.

Thank you,
Yong

Comments

  • James BJames B Posts: 1,124 Silver 4
    The current revision of a given linked database is stored in a DB level Extended Property, so you can view this in SSMS by right-clicking the DB, picking Properties, and looking at the Extended Properties.
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.