Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lcannon
Starting Member
3 Posts |
 Posted - 2005-09-07 : 10:16:57
|
| I need help to create a stored procedure to get the table names from a database and create a Union view. There are over 100 tables. |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-09-07 : 10:36:33
|
| Why do you need to union over 100 tables? That sounds very much like you might have some serious design issues .... Can you give us some more info? |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-07 : 14:00:22
|
Might be a horizontal partition?EDIT: Actually, hopefully not for a post in "New to SQL Server"  Kristen |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-07 : 23:03:25
|
| you could basically start withselect table_name from information_schema.tables where table_type='table'this is already a view, what do you mean by union? what to union? do you need to identify same table names but different owners?--------------------keeping it simple... |
|
|
|
|
|
|
Stored Procedure Table names to view