You are hereSQL SERVER - 2005 - List Tables in Database

SQL SERVER - 2005 - List Tables in Database

By edwin - Posted on 23 March 2009

This is very simple but effective script. It list all the table names.

USE DatabaseName;
GO
SELECT SCHEMA_NAME(schema_id) AS SchemaName,name AS TableName
FROM sys.TABLES
ORDER BY SchemaName, TableName;
GO

Bookmark/Search this post with

Tags

Submitted by Ved Prakash (not verified) on Tue, 08/11/2009 - 23:47.

getting Error

Msg 195, Level 15, State 10, Line 1
'SCHEMA_NAME' is not a recognized function name.

Submitted by Anonymous (not verified) on Wed, 08/12/2009 - 08:31.

Apparently, this happens when you have two versions of SQL Server installed on the same computer. Go to a command prompt and re-register sqldmo.dll.

Regsvr32 Sqldmo.dll

You should get a prompt back that states DLLRegisterServer in SQLDMO.dll succeeded.
Reboot your server and try again.

Post new comment