finding which fields are "nullable"
Posted on 2013-07-01
i'm looking for a piece of sql that will enable me to see which fields in a table can have null values.
i've tried select * from syscolumns where id=(select id FROM sysobjects where name='table_name') but this doesn't give that attribute.
i'm calling this sql from VBA, so i cannot use sp_help as the "nextrecordset" method doesn't work when using sybase