Re: Retrieve SQLserver table list

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Alex Feinman [MVP] (public_news_at_alexfeinman.com)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 11:14:19 -0700

Select * from Information_Schema.tables

If you run this query, you will get a list of tables in the SQL CE database 

-- 
Alex Feinman
---
Visit http://www.opennetcf.org
"Zanna" <znt.fabio@virgilio.it> wrote in message
news:2its6mFqlmbsU3@uni-berlin.de...
> William Ryan eMVP ha scritto:
>
> >   You can just use SysObjects if you're after full sql server, where
xtype =
> > 'S' or xtype = 'U'.  You can use Information_Schema.Tables or Columns
etc to
> > find out more specific information if need be.
>
> Thank you: the SysObject seems to be what I need.
>
> But I didn't understand what you mean with the Information_Schema.Tables
> tip.
>
> Thanks again.
>
> -- 
> Math Parser : http://www.neodatatype.net

Relevant Pages