Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mark All fields in a table as NULL

Status
Not open for further replies.

FoxT2

MIS
Oct 3, 2003
143
US
Hello,

I have several tables that I imported into SQL server. The problem is that I need all my fields in certain tables to accept NULL values, however, the file definitions show that the accept null values column is not checked. Is there a way to select all the fields in a table and check them for NULL values versus checking each individaul field seperatly. Having to check each field seperatly will take a long time to accomplish this. I am using SQL server enterprise manager as my interface.

Thanks,

FoxT
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top