Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-11 : 14:02:18
|
| Randy writes "SQL 7 on Win2000. How about a quick way to change all fields in a table to accept null values when, for example, the table was created with a 'create table' DTS load package that set all fields to not accepting nulls. Opening the table in Enterprise Manager and clicking the null box on 200 fields isn't fun. I've used Excel to create one alter table statement, then paste in field names, types and drag down repeating columns so as to have a copy and paste method into query analyzer, but this is still slow." |
|
|
|
|
|
Change all fields to accept null values