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: 
try this to get the definition of table in SQL...

> 
> sp\_help 'tableName'
> 
> 
> 

example `sp_help 'MyTable'`

We can also do same thing as

```
exec sp_help 'MyTable'

```

Because **sp\_help** is a pre define *stored processor* and we can execute stored processor using "**exec**" keyword or also can use "**execute**" keyword
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

```