Database schema using GetSchema

  • Thread starter Thread starter JPS
  • Start date Start date
J

JPS

I tried using GetSchma to return all of the tables in the database, but
this doesn't seem to work. What I am trying to do is get schema
information on all of the tables in one databes and then all of the
fields in each table and their properties.
Can anyone show me a code sample of how to do this besides the
MSFTexamples which tell me nothing.?
 
In Sql Server:
Select * From Information_Schema.Tables
gets all tables

Select * From Information_Schema.[Columns]
gets all columns in all tables (with data types etc)

You can use normal where clauses etc on these.

HTH

Ciaran O'Donnell
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL 2005 - call to get all tables in a DB 4
Access Database Schema 5
Unable to Update A Table Schema Progmatically 1
Database Schema 3
GetSchema from multiple tables 1
How does GetSchema get foreign key constraints? 4
copy data from one datatable to another - different schemas 2
Deploy CLR UDF to a different SQL Schema 4

Back
Top