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
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