DISPLAY TABLE NAMES IN SQL code example

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

DESCRIBE Table_Name;

OR 

DESC Table_Name;

Example 2: sql show table name in result

select ID, 'Actor' as Career, Name from Actor
union all
select ID, 'Singer' as Career, Name from Singer