Get 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'