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?