microsoft sql server search table names code example

Example 1: sql server find table name

select * from sys.tables where name like '%tablename%'

Example 2: How to View column names of a table in SQL

DESCRIBE Table_Name;

OR 

DESC Table_Name;

Example 3: get all columns from table sql

SELECT
  	TABLE_NAME
FROM
  	INFORMATION_SCHEMA.TABLES

Tags:

Sql Example

Related