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
Seba Sama
0
Light Poster
Recommended Answers
Jump to PostUse INFORMATION_SCHEMA. Example:
SELECT TABLE_SCHEMA,TABLE_NAME, OBJECTPROPERTY(object_id(TABLE_NAME), N'IsUserTable') AS type FROM INFORMATION_SCHEMA.TABLESThere 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 …
All 2 Replies
hollystyles
113
Veteran Poster
Use INFORMATION_SCHEMA. Example:
SELECT TABLE_SCHEMA,TABLE_NAME, OBJECTPROPERTY(object_id(TABLE_NAME), N'IsUserTable') AS type
FROM INFORMATION_SCHEMA.TABLESThere 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.
Seba Sama
0
Light Poster
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.