Want to become a Vibe Coder? Join Vibe Coding Training here
x
C# Corner
Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
List All Tables of Database Using SQL Query
WhatsApp
Nitin
9y
112.2
k
0
1
25
Blog
Write the following query and execute.
SELECT
*
FROM
sys.Tables
There is another query that we can use to achieve the same.
Write the following query.
SELECT
*FROMinformation_schema.tables
Wel, there is one more way by which we can list all the tables in a database. Write the following query in the query analyzer.
SELECT
sobjects.
name
FROM
sysobjectssobjects
WHERE
sobjects.xtype=
'U'
SQL Server
SQL Query
Table
People also reading
Membership not found