How can we help you today? How can we help you today?

How to check database schema version

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
kulmam92
0

Comments

1 comment

  • James B
    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.
    James B
    0

Add comment

Please sign in to leave a comment.