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 |
|
khalik
Constraint Violating Yak Guru
443 Posts |
 Posted - 2002-04-24 : 22:12:34
|
| can any one give me how and where can we use extended property ....i tried out thisCREATE table T1 (id int , name char (20))GOEXEC sp_addextendedproperty 'caption', 'Employee ID', 'user', dbo, 'table', T1, 'column', idhow can i make use of property capiton10xs======================================Ask to your self before u ask someone |
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-04-25 : 06:05:39
|
| *bumpwhat happen i see no guru.... around======================================Ask to your self before u ask someoneEdited by - khalik on 04/26/2002 03:41:23 |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-04-26 : 17:58:07
|
Since your example is directly copy and pasted out of BOL, then I guess it's okay for my response to be, too.quote:
Extended properties are managed using three system stored procedures: sp_addextendedproperty, sp_updateextendedproperty, and sp_dropextendedproperty. You can read the value of an existing extended property using the system function FN_LISTEXTENDEDPROPERTY.There is no convention or standard for defining extended properties. The database designer sets the rules specifying the property names and contents when the database is designed, and then the applications accessing the database have to be coded to follow those rules or conventions.
|
|
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-04-30 : 01:23:05
|
quote:
Since your example is directly copy and pasted out of BOL, then I guess it's okay for my response to be, too.
that cool all i was looking is how i can use extended property..where is can be use full10xs======================================Ask to your self before u ask someone |
|
|
|
|
|
|
|
|
extended property