how to selct particular table from given tables in db code example

Example 1: sql server find table name

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

Example 2: get all columns from table sql

SELECT
  	TABLE_NAME
FROM
  	INFORMATION_SCHEMA.TABLES