How we can find all tables name of particular database in SQL

How we can find out all tables of particular database in sql ??

Steps are :

Write below mentioned query in sql :-

      select name  from sys.tables