How do you list the Extended Events for the Table

Question

How do you list the Extended Events for the Table

Welsh Corgi

SSC Guru

Points: 116520
More actions
June 21, 2016 at 11:16 am

#308553

The following list the Extended Properties for each column in a table:
SELECT * FROM ::fn_listExtendedProperty
(DEFAULT,'schema', 'dbo', 'table', 'Event', 'column',DEFAULT)
How do you list the Extended Properties for a Table?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

Correction: Extended Properties for a table?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Lowell SSC Guru Points: 323547 More actions · Answer 2

Welsh Corgi (6/21/2016)
The following list the Extended Properties for each column in a table:
SELECT * FROM ::fn_listExtendedProperty
(DEFAULT,'schema', 'dbo', 'table', 'Event', 'column',DEFAULT)
How do you list the Extended Properties for a Table?

just start nulling out parameters from right to left to get wider and wider scope

leave the last two properties as NULL, nad you get all properties for the table, along with all properties for columns.

null all values, nad you see everything in the database.

SELECT * FROM ::fn_listExtendedProperty

(NULL,NULL, NULL, NULL, NULL, NULL,NULL)

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

I tried this and I got nothing:

SELECT * FROM ::fn_listExtendedProperty

(NULL,NULL, NULL, NULL, NULL, NULL,NULL)

I tried this and it only returned the value for the table:

SELECT * FROM ::fn_listExtendedProperty

(DEFAULT,'schema', 'dbo', 'table', 'CATEvent', NULL,NULL)

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/