Get the list of all tables of a database

Click here to hide categories Click here to show left categories

User: Home welcome : Guest Log In / Register here

Asp.Net 2.0

C++ Programs/Algorithms

ASP.NET 2.0 & 3.5 / Ajax

Design Patterns

Website Hosting

.Net Video Tutorials

jQuery & ASP.NET

General Concepts

C++ Concepts

Usable Codes

Google Stuff

Tips & Tricks (Fun Stuff)

Errors : Asp.Net

Errors : Sql Server

Software Testing

Data Structures

Data Structures Programs/Algorithms

Quick Test Professional (QTP)

C# Interview questions

C# Interview

Technical Analysis

Get the list of all tables of a database



In sql server 2005, We can get the list of tables from the Sys.Tables from a database. With the below query we can get the list of all tables in a database. SELECT * FROM sys.Tables With below query we may find the list of Views also with the tables. SELECT * FROM information_schema.Tables




Share this article \| Print \| Article read by 1650 times
Author: Rohit kakria I am software developer, moderator of xpode.com	Related Articles: Insert Multiple records with single Insert stat... Create queries of database tables with its data... Insert Multiple records with single Insert stat... Turning Off and On Identity Column in SQL Serve... Related Interview Questions: Insert Multiple records with single Insert stat... Create queries of database tables with its data... Insert Multiple records with single Insert stat... Turning Off and On Identity Column in SQL Serve... What is difference between nchar & nvarchar... What is Stored procedure...