|
Home > Archive > MS SQL Server > November 2006 > Schema changes to SQL Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Schema changes to SQL Server
|
|
| System Audit 2006-11-09, 7:13 pm |
| I am working with an old version of SQL Server (6.5), but the same
mechanism may exist in later versions.
If there were any changes made to the database schema, would this be
recorded somewhere within the database?
Would there be some way of determining if there had been any schema
changes within the past year?
I am presuming all schema changes would be mediated by the SQL command:
"ALTER TABLE"
Thanks!
| |
| Hilary Cotter 2006-11-09, 7:13 pm |
| You will get some reference to changes by querying the sysobjects table. For
example if you add a constraint it will appear as a new entry with a crdate
of now. There is no tracking for adding or dropping columns.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"System Audit" <patrick.girling@gmail.com> wrote in message
news:1163078695.253096.165370@b28g2000cwb.googlegroups.com...
>I am working with an old version of SQL Server (6.5), but the same
> mechanism may exist in later versions.
>
> If there were any changes made to the database schema, would this be
> recorded somewhere within the database?
>
>
> Would there be some way of determining if there had been any schema
> changes within the past year?
>
>
> I am presuming all schema changes would be mediated by the SQL command:
>
> "ALTER TABLE"
>
>
> Thanks!
>
| |
|
| System Audit wrote:
> I am working with an old version of SQL Server (6.5), but the same
> mechanism may exist in later versions.
>
> If there were any changes made to the database schema, would this be
> recorded somewhere within the database?
>
>
> Would there be some way of determining if there had been any schema
> changes within the past year?
>
>
> I am presuming all schema changes would be mediated by the SQL command:
>
> "ALTER TABLE"
>
>
> Thanks!
>
Hi
SQL server doesn't keep this kind of info.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
|
|
|
|
|