Advertisement

07.08.2008 at 02:58AM PDT, ID: 23545972 | Points: 250
[x]
Attachment Details

How to export column descriptions for each column header in an SQL table into excel?

Asked by orazen11 in PL / SQL, SQL Server 2005, dBase

In SQL, I was looking to add some kind of description that I could associate with the column names in a table and also fetch from SQL into excel along with the column names & data. Basically I need both column names and their descriptions along with the data.
My post includes the code using which I can add descriptions to objects like columns. The second part gives a query which displays the column descriptions when run from SQL, but does not return them when run from excel using ADO.

Why is this the case only with description? I mean I am able to export into excel the table names and column names using the query I have pasted in my previous post, then why am I not able to export column descriptions?Start Free Trial
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
-- For adding a description to a column
USE vns_db;
GO
EXEC sys.sp_addextendedproperty
@name = N'description_name',  
@value = N'description_value', 
@level0type = N'SCHEMA', @level0name = dbo,    
@level1type = N'TABLE',  @level1name = risk_parameters,  
@level2type = N'COLUMN', @level2name = branch_client; 
GO
 
 
 
 
 
-- For fetching the column name & description
SELECT 
    [Table Name] = OBJECT_NAME(c.object_id),
    [Column Name] = c.name,
    [Description] = ex.value 
FROM 
    sys.columns c 
LEFT OUTER JOIN 
    sys.extended_properties ex 
ON 
    ex.major_id = c.object_id
    AND ex.minor_id = c.column_id 
WHERE  
    OBJECT_NAME(c.object_id) = 'risk_parameters'  
ORDER 
    BY OBJECT_NAME(c.object_id), c.column_id
[+][-]07.08.2008 at 09:40AM PDT, ID: 21955563

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.08.2008 at 11:47AM PDT, ID: 21956786

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.09.2008 at 07:09AM PDT, ID: 21963740

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.09.2008 at 07:14AM PDT, ID: 21963806

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_Related_20080208