Extended Property

Hello All
I am Not aware about the Extended Property. Can Anyone
explain me what is Extended Property... where it use ... how it use..
I have an store procedure along with parameter is calling, But I am not
able to understand the
this store procedure.
exec sp_addextendedproperty 'FKLookupDisplay', 'Description', 'user',
dbo, 'table', 'Amortization'
What the above store procedure does 'hi,
tarun.sinha@.gmail.com wrote:
> Hello All
> I am Not aware about the Extended Property. Can Anyone
> explain me what is Extended Property... where it use ... how it
> use..
> I have an store procedure along with parameter is calling, But I am
> not able to understand the
> this store procedure.
> exec sp_addextendedproperty 'FKLookupDisplay', 'Description', 'user',
> dbo, 'table', 'Amortization'
> What the above store procedure does '
have a look at http://www.devx.com/dbzone/Article/27793/0
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply|||I have understood the the Extended Property but it not crystal clear ,
Can any one explain a bit with example '
Andrea Montanari wrote:
> hi,
> tarun.sinha@.gmail.com wrote:
> have a look at http://www.devx.com/dbzone/Article/27793/0
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
> -- remove DMO to reply|||hi,
tarun.sinha@.gmail.com wrote:
> I have understood the the Extended Property but it not crystal clear ,
> Can any one explain a bit with example '
SET NOCOUNT ON;
USE tempdb;
GO
CREATE TABLE dbo.testTable (
Id int NOT NULL
);
GO
PRINT 'adding 2 extended properties to the table object';
EXEC sp_addextendedproperty 'prop_name' , 'property value' , 'user' , 'dbo'
, 'table' , 'testTable' , NULL , NULL;
EXEC sp_addextendedproperty 'prop_name2' , 'property value' , 'user' , 'dbo'
, 'table' , 'testTable' , NULL , NULL;
PRINT 'modifying an extended property value';
EXEC sp_updateextendedproperty 'prop_name' , 'new property value' , 'user' ,
'dbo' , 'table' , 'testTable' , NULL , NULL;
PRINT 'lists all extended properties available on dbo.testTable';
SELECT * FROM ::fn_listextendedproperty( NULL , 'user' , 'dbo' , 'table' ,
'testTable' , NULL , NULL );
PRINT 'drop an extended property';
EXEC sp_dropextendedproperty 'prop_name', 'user' ,'dbo' , 'table' ,
'testTable';
GO
DROP TABLE dbo.testTable;
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply