Table information in sql server

SELECT
  	TABLE_NAME
FROM
  	INFORMATION_SCHEMA.TABLES
/******************************************************/
EXEC sp_help dbo.mytable;
/******************************************************/
EXEC sp_columns dbo.mytable;

Source: chartio.com

Similar codes

0 vote179 views2 answers
Mysql on update current_timestamp
SQL
2 votes202 views1 answer
Oracle sql merge
SQL
0 vote187 views1 answer
Postpresql relation not found
SQL
2 votes183 views2 answers
Enable foreign key checks postgres
SQL
0 vote187 views1 answer
Sql select most frequent value in column
SQL
1 vote197 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote177 views1 answer
Console output pl sql
SQL
0 vote182 views1 answer
Oracle gather table statistics
SQL
-2 votes200 views1 answer
How to open database
SQL
6 votes203 views3 answers
What is where in sql
SQL