jude
Reputation: 55
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
Upvotes: 2
Views: 155
Answers (2)
Remus Rusanu
Reputation: 294207
- column nullability:
sys.columns.is_nullable - index uniqueness:
sys.indexes.is_unique - index key ascending/descending:
sys.index_columns.is_descending_key
Upvotes: 2
IordanTanev
Reputation: 6240
SELECT * FROM INFORMATION_SCHEMA.COLUMNS -- gives column info SELECT * FROM sys.indexes --gives info for indexes
Upvotes: 0
Related Questions
- Unique constraint on another column if not null
- How do I create a unique constraint that also allows nulls?
- How to add a unique constraint for 2 nullable columns?
- Unique constraint on multiple columns when any columns are not null
- Field having unique and not null
- unique constraint with a condition to accept multiple nulls on a unique column
- How can make Column that allow null to be unique from SQL Server 2005?
- Unique Constraint column can only contain one NULL value
- Unique constraint only over NON-NULL columns
- Violation of UNIQUE KEY constraint on null