sql statements

[pnpfriend]

what is the sql statement to get the name of all tables exiting in a database thank you

[Henrik Stuart]

USE db;
GO

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE';

For instance. Presuming, of course, you're talking about MSSQL Server. -- Henrik Stuart (http://www.unprompted.com/hstuart/)

[dishanf]

SELECT * FROM sysobjects WHERE type = 'U' D!shan

[Arjan Einbu]

Use the INFORMATION_SCHEMA approach that Henrik Stuart described, since MS can and probably will change the structures many of its system tables in future versions of SQL Server. The results of using the INFORMATION_SCHEMA viewvs are guaranteed to stay the same in all never versions of SQL Server.

---

Have a look at my latest article about Object Prevalence with Bamboo Prevalence.