table names list

• anakin

  SSC Veteran

  Points: 272

  More actions

  October 29, 2002 at 7:19 am

  #80254

  hi,

  Can somebody show me an example of "sp_tables" sql-server stored procedure use, to list database table's names to a VB program ?

  If is there an other way to discover all the tables name of my sql server database to load a listbox, is ok too.

  Thanks

  anakin

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  October 30, 2002 at 1:09 am

  #439775

  SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'

  --

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  http://www.sql.nu

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/