AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Adventureworks2012 schema3/17/2024 The following example lists extended properties for columns in the ScrapReason table. The following example displays all extended properties set on the database object itself.įROM fn_listextendedproperty(default, default, default, default, default, default, default) ĭisplaying extended properties on all columns in a table , ĭisplaying extended properties on a database Returns extended property values of database objects. Sys.fn_listextendedproperty (Transact-SQL) By default it will show you this information for every single table and view that is in the database. The INFORMATION_SCHEMA.COLUMNS view allows you to get information about all columns for all tables and views within a database. The INFORMATION_SCHEMA.TABLES view allows you to get information about all tables and views within a database. On INFORMATION_NAME=fn_listextendedproperty.objname Left join fn_listextendedproperty (NULL, ‘schema’, ‘Production’, ‘table’, ‘Product’, ‘column’, default)
0 Comments
Read More
Leave a Reply. |