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 |
|
oxegg
Starting Member
6 Posts |
 Posted - 2010-07-30 : 03:05:01
|
| Hello fabulous world!I know how to use fn_listextendedproperty,but I don't know how to use it for view??I look for the SQL Server 2000 online instruction,it descript that I can use TABLE?VIEW?PROCEDURE?FUNCTION?DEFAULT?RULE?NULL.but if I use below SQL syntax:SELECT * FROM fn_listextendedproperty(NULL,'user','dbo','view','xxx','column',DEFAULT)I assume the 'xxx' is a view but the result return nothing.I know below syntax which can work successful:SELECT * FROM fn_listextendedproperty(NULL,'user','dbo','table','myTable','column',DEFAULT)But....Why 'view' can't work?To consult EveryBody and Thanks very much. |
|
|
oxegg
Starting Member
6 Posts |
Posted - 2010-07-30 : 03:28:59
|
| SORRY...I type wrong!I should type below statement:SELECT * FROM ::fn_listextendedproperty(NULL,'user','dbo','view','xxx','column',DEFAULT)AND below statement:SELECT * FROM ::fn_listextendedproperty(NULL,'user','dbo','table','myTable','column',DEFAULT) |
 |
|
|
|
|
|
|
|
fn_listextendedproperty for VIEW?