hi there!
I've been working on a project in ASP.NET and SQLserver 2000.
Since this is actually something for school, I must give a report on my work done here.
What I want to do is make an attributelist of all the tables that are in a database, or one at the time would already be a great help!
So for each table I would need in text format all its column names, types en 'allow null' property, but I just can't find out how or with what to do this.
thanks for your help!
Tombaselect * from INFORMATION_SCHEMA.COLUMNS
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment