Table infromation 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

1 vote233 views2 answers
Rebuild index sql server
SQL
1 vote233 views2 answers
Oracle list partitioned tables
SQL
1 vote221 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
3 votes241 views2 answers
Sql paging query
SQL
0 vote275 views1 answer
Dual in db2
SQL
0 vote241 views1 answer
Get a list of tables and the primary key
SQL
1 vote295 views1 answer
Hangfire clear all jobs
SQL
17 votes234 views3 answers
How to change a collumn name in sql
SQL
0 vote261 views1 answer
PostgreSQL types and C# types
SQL
4 votes232 views4 answers
What is primary key
SQL