OpenSchema
I am building a small tool that will be used to compare 2 database to find differences. I want this tool to work at least with SQL and Access databases.
For that topic I use a mixture of ADO and ADOX (to have the most detail possible).
My problem for now is that I can retreive the Description field for Access tables and columns but not for SQL.
This is my code to get the description:
' ----- Retrieve the description from standard ADO since ADOX doesn't
' have it recorded.
Set rsInfo = connSchema.OpenSchema(adSc
Array(Empty, Empty, sTableName, "TABLE"))
If Not (rsInfo.EOF) Then GetTableDesc = rsInfo!Description & ""
How can I retreive that?
For that topic I use a mixture of ADO and ADOX (to have the most detail possible).
My problem for now is that I can retreive the Description field for Access tables and columns but not for SQL.
This is my code to get the description:
' ----- Retrieve the description from standard ADO since ADOX doesn't
' have it recorded.
Set rsInfo = connSchema.OpenSchema(adSc
Array(Empty, Empty, sTableName, "TABLE"))
If Not (rsInfo.EOF) Then GetTableDesc = rsInfo!Description & ""
How can I retreive that?
TimCottee
Is there such a thing as a description field for a SQL server table? I don't remember seeing this and cannot find it in SQL7 sp3.
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
Hi,
as far as i know, there is only a description from SQL2k on... i will try your code on my SQL2k box and tell you the results...
Cheers
as far as i know, there is only a description from SQL2k on... i will try your code on my SQL2k box and tell you the results...
Cheers
hi, the procedure returns always NULL, as far as i tested...
even this query, which should give the values returns no rows...
SELECT *
FROM ::fn_listextendedproperty ( NULL, NULL, NULL, NULL, NULL, NULL, NULL )
even this query, which should give the values returns no rows...
SELECT *
FROM ::fn_listextendedproperty ( NULL, NULL, NULL, NULL, NULL, NULL, NULL )
ASKER
If you are interested on that topic, I just posted a question into the MS-SQL forum : https://www.experts-exchange.com/jsp/qManageQuestion.jsp?qid=20163025
ASKER
It seems that it is not do able. Do you have any objections if I delete this question?
Unless you prefer it being PAQed by CS, no objections
Me neither
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.