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 |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2011-06-01 : 05:48:06
|
| hello everybody, i want to find out the tables whose columns have null values..thanks in advance |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-01 : 06:12:41
|
| information_schema.columns will show you the columns that are nulable.To find the rows that hold null values you will have to run a query on each table/column.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Ranjit.ileni
Posting Yak Master
183 Posts |
Posted - 2011-06-01 : 06:23:52
|
| You can use IS_NULLABLE column from select * from INFORMATION_SCHEMA.COLUMNS --Ranjit |
|
|
|
|
|
|
find table with null values