not null and is unique constraint

Question

Hi, In SQL Server 2005, which system table holds the information as to whether a column is nullable or not, whether a index is unique or not asc or dec.

Thanks, Jude

Answer 1

hi,

SELECT * FROM INFORMATION_SCHEMA.COLUMNS -- gives column info
SELECT * FROM sys.indexes --gives info for indexes

Answer 2

• column nullability: sys.columns.is_nullable
• index uniqueness: sys.indexes.is_unique
• index key ascending/descending: sys.index_columns.is_descending_key