Wednesday, May 13, 2009

How To Get List of Tables in SQL Server


Using Following SQL Query you can get list of tables in SQL Database

SELECT name [Table Name]
FROM sysobjects
WHERE xtype = 'U'



No comments:

ShareThis

Welcome

Welcome to Rajesh Prajapati, asp.net blog.
Here you can find some useful code and information about asp.net., c#, VB.net, SQL Server, Web Service, Web Designing etc