Show All Tables in Database

Опубликовано: 07 Апрель 2023
на канале: SQL Learning Resources: Dr. Cecelia Allison

7,129

Show All Tables in Database

This video demonstrates how to Show all Tables in a Database in SQL Server Management Studio. When you list all tables in a database it enables you to gain pertinent information about the tables before executing any queries against the database. To view all tables in a database, specific system commands are executed. SQL Server provides many commands to view tables in a database.

Learn SQL FREE ✍with a "Practice Database"!
   • Learn SQL Fast 🚀

Data Science Career Training:
https://www.jaffainc.com/Entrepreneur...

Search "Top Job Listings"!
https://www.jaffainc.com/research-car...

QUERY SYNTAXES

► VIEW ALL TABLES IN THE DATABASE:

SELECT *
FROM information_schema.tables;

► VIEW INFORMATION ABOUT THE COLUMNS OF ALL TABLES IN THE DATABASE:

SELECT *
FROM information_schema.columns;

► VIEW INFORMATION ABOUT A SPECIFIC TABLE:

exec sp_columns NameOfTable;

OR -

sp_help 'Table_Name';

🚀 COOL SQL TIPS AND TRICKS!

ADD Conditional Logic to Queries:
   • SQL Case Statement | Learn SQL Fast 🚀

FIX Common SQL Errors:
   • SQL Server Errors | Fixes and More ⭐

COPY Data from One Table to Another:
   • How to Copy Data from One Table to An...

COMBINE Multiple Strings:
   • Handy SQL Tips & Techniques! 🚀

CREATE an SQL Phone Number Format:
   • SQL Phone Number Format | Learn SQL F...

FORMAT Dates in an SQL Query:
   • Format Date in SQL Query | Learn SQL ...

ALTER Tables in SQL:
   • Alter Tables in SQL | Learn SQL Fast 🚀

ADD Table Constraints to a Table:
   • Add Constraints | Learn SQL Fast 🚀

Query Multiple Tables Simultaneously:
   • INNER Join SQL | Learn SQL Fast 🚀

Get Started Using SQL Server:
   • SQL Server | Get Started!

BOOST YOUR CAREER GROWTH!

🔹 Train for a Career in Data:
https://www.jaffainc.com/Entrepreneur...

🔹 Earn "SQL 🏅 Certifications & CEUs" (Continuing Education Units)
https://www.jaffainc.com/SQLCertifica...

#database #data #sql #sqlqueries #sqlforbeginners #sqltutorial #sqlcertificate #learnsql #sqltraining #sqlserver #relational #sqltips #sqlsyntax #sqlservertutorial #learnprogramming #datascience #databaseskills #dataanalysis #databasecertification #sqlcourse #structuredquerylanguage #practice #sqlpractice #sqlservertutorial #sqlservermanagementstudio #sqlskills