Extended properties catalog views - sys.extended_properties
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
Returns a row for each extended property in the current database.
Column name | Data type | Description |
---|---|---|
class |
tinyint | Identifies the class of item on which the property exists. Can be one of the following values:0 = Database1 = Object or column2 = Parameter3 = Schema4 = Database principal5 = Assembly6 = Type7 = Index8 = User defined table type column10 = XML schema collection15 = Message type16 = Service contract17 = Service18 = Remote service binding19 = Route20 = Dataspace (filegroup or partition scheme)21 = Partition function22 = Database file27 = Plan guide |
class_desc |
nvarchar(60) | Description of the class on which the extended property exists. Can be one of the following values:DATABASE OBJECT_OR_COLUMN PARAMETER SCHEMA DATABASE_PRINCIPAL ASSEMBLY TYPE INDEX XML_SCHEMA_COLLECTION MESSAGE_TYPE SERVICE_CONTRACT SERVICE REMOTE_SERVICE_BINDING ROUTE DATASPACE PARTITION_FUNCTION DATABASE_FILE PLAN_GUIDE |
major_id |
int | ID of the item on which the extended property exists, interpreted according to its class. For most items, this is the ID that applies to what the class represents. Interpretation for nonstandard major IDs is as follows: If class is 0 , major_id is always 0 .If class is 1 , 2 , or 7 , major_id is object_id . |
minor_id |
int | Secondary ID of the item on which the extended property exists, interpreted according to its class. For most items this is 0 ; otherwise, the ID is as follows:If class is 1 , minor_id is the column_id if column, else 0 if object.If class is 2 , minor_id is the parameter_id .If class is 7 , minor_id is the index_id . |
name |
sysname | Property name, unique with class , major_id , and minor_id . |
value |
sql_variant | Value of the extended property. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
Related content
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για