Member Avatar for Seba Sama

Hi
can anyone help me on how to get the names of the tables from a DB - MSSQL 2k server? i need to list them or add them into a combobox, but i also need to select them by owner, or by type. user defned or system.
thx in advance

  • 2 Contributors
  • 2 Replies
  • 457 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by Seba Sama
Member Avatar for hollystyles

Use INFORMATION_SCHEMA. Example:

SELECT TABLE_SCHEMA,TABLE_NAME, OBJECTPROPERTY(object_id(TABLE_NAME), N'IsUserTable') AS type 
 FROM INFORMATION_SCHEMA.TABLES

There are many others, search the index in Books On-lline (the manual you get with SQl Server) for all the others or search the SQLTeam.com forums where there are many posts and articles on getting metadata from MS SQL Server.

Member Avatar for Seba Sama

thx, it helped me a lot.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.