Question: I have a database and a lot of tables inside it. I wrote definition into the each table and column's definition part. And now using query I want to see all table and columns definition.

Can you please help me?

Answer: 
Here's a bass query that can list info from the colums and tables in SQL server. Just add the columns you need from each system table.

```
SELECT 
  t.name table_name,
, c.name column_name
From sys.tables AS t
Inner Join sys.columns c 
  On t.Object_ID = c.Object_ID

```
If you are looking for extended descriptions:

```
SELECT 
  OBJECT_NAME(major_id) TableName,(select name from sys.columns c where c.object_id=major_id and c.column_id=minor_id) ColumnName,*
FROM 
  sys.extended_properties
WHERE 
  name='MS_Description' AND minor_id>0 and class=1

```