How to display table in SQL Code Answer’s
get the list of all tables in sql server
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'
display table in sql
SELECT * FROM TABLE_NAME;
SELECT * FROM table_name; This will give you all the rows from the table, with their field values. It's useful if you have a table of data that you want to show to your users or clients.