[SQL Server] Ajouter et afficher une description pour une colonne d'une table
EXEC sp_addextendedproperty
@name=N'MS_Description',
@value=N'ARCHIVE;AND champs_2<>5',
@level0type = N'SCHEMA',@level0name='dbo',
@level1type = N'TABLE',@level1name='MaTable_1',
@level2type = N'COLUMN',@level2name='champs_1'
EXEC sp_addextendedproperty
@name=N'MS_Description',
@value=N'ARCHIVE;AND createdByBatchImport = 0',
@level0type = N'SCHEMA',@level0name='dbo',
@level1type = N'TABLE',@level1name='MaTable_2',
@level2type = N'COLUMN',@level2name='champs_2'
SELECT OBJECT_NAME(T1.major_id) AS TableName,T2.name AS ColumnName, T1.value AS Description
FROM sys.extended_properties T1
JOIN sys.columns T2 ON T1.major_id=T2.object_id AND T1.minor_id=T2.column_id
WHERE T1.name='MS_Description'
AND CAST(T1.value AS NVARCHAR(10)) LIKE 'ARCHIVE%'
--AND OBJECT_NAME(T1.major_id)='MaTable_1'