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

15 votes114 views2 answers
Open postgress in terminal mac
SQL
0 vote186 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote113 views1 answer
Postgresql create table default value timestamp
SQL
1 vote114 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
31 votes123 views4 answers
How to get duplicate records with multiple field in sql
SQL
18 votes119 views3 answers
Get the list of all tables in sql server
SQL
0 vote124 views1 answer
Postgres foreign key multiple columns
SQL
1 vote117 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
0 vote113 views2 answers
Which MySQL statement is used to delete data from a database
SQL
-1 vote95 views1 answer
Plsql while
SQL