get the tables in sql server code example

Example: get tables in database sql

SELECT
  *
FROM
  INFORMATION_SCHEMA.TABLES;