Get table information of Sql server database.

here i will show how you can show the table information of sql server database.

Sql Query:
select * FROM sysobjects

it will show the details of all system table and users table

if you want information of specific table,then you can specify table name in where clause.

ex.
select *
FROM sysobjects
where name='table_name_here'