|
select
dc.object_id,
dc.parent_object_id,
dc.name,
dc.definition,
c.name as ColumnName,
t.name as TableName,
s.name as [Schema],
[Description] = ISNULL((select value from fn_listextendedproperty ('MS_Description', 'schema', s.name, 'table', t.name, 'CONSTRAINT', dc.name)),N'')
from
sys.check_constraints dc join sys.columns c on dc.parent_object_id=c.object_id and dc.parent_column_id=c.column_id
left join sys.tables t on t.object_id=dc.parent_object_id
left join sys.schemas s on s.schema_id = t.schema_id;
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
My name is Robert Kanasz and I have been working with ASP.NET, WinForms and C# for several years.
MCSD - Web Applications
MCSE - Data Platform
MCPD - ASP.NET Developer 3.5
- Web Developer 4
MCITP - Database Administrator 2008
- Database Developer 2008
MCSA - SQL Server 2012
MCTS - .NET Framework 3.5, ASP.NET Applications
- SQL Server 2008, Database Development
- SQL Server 2008, Implementation and Maintenance
- .NET Framework 4, Data Access
- .NET Framework 4, Service Communication Applications
- .NET Framework 4, Web Applications
MS - Programming in HTML5 with JavaScript and CSS3 Specialist
Open source projects:
DBScripter - Library for scripting SQL Server database objects
Please, do not forget vote