Finding all Nullable Columns in SQL 2000 Database

Question

How to find out column with NULL values allowed in the insert in whole database ?

Answer 1

I don't have sql at hand, but the query goes something like this

  SELECT * FROM information_schema.columns WHERE is_nullable = 'YES'

In general, search for this stardard view, for all the metadata info about your schema and structure of the database; there are many others (information_schema.tables, information_schema.constraints, etc)