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: 
If you're using SqlServer.

```
SELECT obj.name, cols.name as columnname
from dbname.sys.objects as obj
inner join dbname.sys.columns as cols
on obj.object_id = cols.object_id
where obj.type='U'

```
Try this :

```
SELECT * FROM INFORMATION_SCHEMA.COLUMNS

```

OR

for more detailed table information

```
EXEC sp_help [Your Table_Name]

```