not null and is unique constraint

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

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

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