how to select tables information from Database in MsSQL

 

select tables information from Database in Ms-SQL

Select * from information_schema.tables

  OR

SELECT * FROM sys.Tables

by: VidyaGyan