title: Select Extended Property from SQL Server tables
body: <p>I am writing a simple CMS for a client's database.  There are 12 tables and they need to manage all of the data in 4 of them.</p>
  
  <p>I set up a dynamic data project (Linq-to-SQL as that's what I'm most familiar with) and the first page makes all 12 tables available for edit as it should.  These are in an enumerable list called visibleTables.</p>
  
  <p>Next I went into SSMS and created an extended property called UserEdit and set it to 0 or 1 depending on whether the user should see it on that screen.</p>
  
  <p>What I would love to do is filter the visibleTables list by that extended property but don't know how to.  </p>
  
  <p>I am able to see the list of tables and the property with this query:</p>
  
  <pre><code>select major_id, name, value
  from sys.extended_properties
  where name = 'UserEdit'
  </code></pre>
  
  <p>and I was going to loop through the visibleTables and remove the ones with 0s but I haven't figured that out either yet as the major_id doesn't seem to be a property I can find.</p>