How to check database schema version

kulmam92kulmam92 Posts: 12
edited May 22, 2013 11:22AM in SQL Source Control Previous Versions
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
· Share on Twitter

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

    · Share on Twitter
Sign In or Register to comment.