display table in sql code example
Example 1: 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'
Example 2: display table in sql
SELECT * FROM table_name;
Example 3: sql show tables
Showing all table:
show tables;
Showing table data:
SELECT
* or column_names
FROM
table_name;
Example 4: css in sql query
SELECT 'test1' AS [@class]
, ( SELECT 'test2' as [@class]
, (SELECT 'Name' FOR XML PATH(''))
FOR XML PATH('td'), type)
,(SELECT 'test3' as [@class]
, (SELECT 'Value' FOR XML PATH(''))
FOR XML PATH('td'), type)
FOR XML PATH('tr'), type
Example 5: 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
Example 6: how select from db
SELECT columname FROM tablename