Retrieve SQLserver table list

  • Thread starter Thread starter Zanna
  • Start date Start date
Z

Zanna

Hi all!

Does anyone know a way to retrieve all the tables present in a DB
SqlServer using the CF?

Thanks!
 
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.

HTH,

Bill
 
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.
Click to expand...

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.
 
Select * from Information_Schema.tables

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