Paddling in the murky bits of the byte stream
Thursday, March 04, 2010
A handy bit of T-SQL was passed to me today (by
) which returns all the fields in a given table which are non-null...
SELECT * FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = '
' and is_nullable = 'NO'
Of course, you'll see there are lots of other fields which can be inspected, so play around and introspect that DB!
Post a Comment
Post Comments (Atom)