How to check database schema version

kulmam92

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

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.