Displaying tables in a database

R

raBBish

New Member
How would I go about displaying all the tables in a database? I just want to populate a dropdown with the table names.This query should get you all of the non system tables in a SQL Server database:<BR><BR>SELECT name AS TableName<BR>FROM sysobjects<BR>WHERE xtype = 'U'<BR>AND name <> 'dtproperties'<BR><BR>hth,<BR>Alex<BR><BR>ASP.NET Examples/Tips: http://aspalliance.com/aldotnet
 
You must log in or register to reply here.
Back
Top