|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Thursday, February 10, 2011 12:36 PM
Points: 116,
Visits: 181
|
|
I was created a table with some columns inside it. For example, I have a table with name "TableX". This tables consists of some columns: ColumnA, ColumnB and ColumnC.
By using SQL Server Management Studio, I was set the information for "Description" in ColumnA.
The problem now is how to see the description of columns? I'm sure that it is stored in table but I don't know what is name of the table.
Any help or direction is greatly appreciated
|
|
|
|
|
SSChampion
        
Group: General Forum Members
Last Login: Today @ 4:36 PM
Points: 11,627,
Visits: 27,690
|
|
there is a view you can select from, and a function that you can use as well:
select * FROM fn_listextendedproperty (NULL, NULL, NULL, NULL, NULL, NULL, NULL); select * from sys.extended_properties
when you add the description in designer, it's actually calling the procedure sys.sp_addextendedproperty to add the description you are thinking about.
Lowell
--There is no spoon, and there's no default ORDER BY in sql server either. Actually, Common Sense is so rare, it should be considered a Superpower. --my son
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Thursday, February 10, 2011 12:36 PM
Points: 116,
Visits: 181
|
|
Thank you very much.
It works completely.
Here are my scripts:
EXEC sp_dropextendedproperty @name = 'MS_Description' ,@level0type = 'schema' ,@level0name = dbo ,@level1type = 'table' ,@level1name = 'DataDelphier' ,@level2type = 'column' ,@level2name = Email; GO
EXEC sp_addextendedproperty @name = N'MS_Description', @value = 'Eko Indriyawan Cakep Sekali', @level0type = N'Schema', @level0name = dbo, @level1type = N'Table', @level1name = DataDelphier, @level2type = N'Column', @level2name = Email;
GO
select * from sys.extended_properties
GO
|
|
|
|
|
Old Hand
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:08 AM
Points: 342,
Visits: 1,072
|
|
|
|
|