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 vote266 views1 answer
How to change mysql root password in windows 10
SQL
2 votes219 views1 answer
Mysql sysdate
SQL
8 votes259 views1 answer
Mysql dump restore
SQL
32 votes239 views6 answers
How to change column name in sql
SQL
0 vote251 views2 answers
Mysql show foreign keys
SQL
20 votes270 views4 answers
How to find average in sql
SQL
4 votes250 views2 answers
Float postgres
SQL
1 vote250 views1 answer
Opensuse restart MySQL
SQL
0 vote207 views1 answer
Sql gap missing values
SQL
4 votes229 views1 answer
Id increment ms sql server
SQL