get the list of all tables in sql server
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'
sql show tables
Showing all table: show tables; Showing table data: SELECT * or column_names FROM table_name;
how to check table name in current database sql
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG=db_name() and TABLE_NAME like'%table_name%'--to check particular table
return columns from table sql
SELECT * FROM INFORMATION_SCHEMA.COLUMNS -- INFORMATION_SCHEMA is an ANSI-standard (American National Standard Institute) set of read-only views which provide information about all of the tables, views, columns, and procedures in a database WHERE TABLE_NAME = N'Customers' -- "N" defines the subsequent string (the string after the N) as being in unicode
Source: stackoverflow.com
display table in sql
SELECT * FROM TABLE_NAME;