Have a live SQL Server 2000 db with approx. 100000 records in it, lots of users etc.<BR><BR>I just want to rename a field so I'm assuming that since this is purely a meta data change, there are not ...
I know in Oracle you can use DBA_TAB_COLUMNS (or ALL_TAB_COLUMNS). My SQL Server knowledge is very rusty, but can't you use the INFORMATION_SCHEMA.COLUMNS view?
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback