1. You could use SQL-DMO
2. (not recommended):
where type = 'U'
3. select TABLE_NAME
where TABLE_TYPE = 'BASE TABLE'
I am in the process of adding Field (Owner) to the existing table of SQL 7.
In Microsoft Access I can use the TableDef to programmatically add field to
them. But in SQL, I don't think It work that way. Could anyone suggest any
alternative for enumerate the tables in SQL database.
12. create tabledef
13. TableDef Method