Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-14 : 09:11:50
|
| George Keradinides writes "Hi, I'm writing a reporing tool from VB6-SP5 for Ms Sql 2000-SP1.Sql2000 has a new feature, called Extended Properties. You can define properties in columns (also tables, views) and retrieve them. I will use this properties to store information about column names (Customer code instead of Cust_ID), font used for display, format, if the column will have a total in report, etc.I can retrieve this properties through ::fn_listextendedproperty.What I need is to create a view, a function or a stored procedure to combine information for this properties, with information about column type, length, scale and possible link with another primary column through a foreign key (to make a user invisible join with the other table if needed).In other words I need to combine informationschema.columns, syscolumns, sysforeignkeys and ::fn_listextendedproperty.Thanks" |
|
|
|
|
|
View for Extended Properties