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
Try this :

```
SELECT * FROM INFORMATION_SCHEMA.COLUMNS

```

OR

for more detailed table information

```
EXEC sp_help [Your Table_Name]

```