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 |
|
heze
Posting Yak Master
192 Posts |
 Posted - 2007-06-18 : 15:01:25
|
| hi does somebody know if is it possible to create views of tables that do not exist yet? but that will exist at some point?my problem is that I have a set os sprocedures that build views over tables that may not exist, I would like to see if it is possible to not having to create the base tables previously, right now even though the procedure that builds the underlying tables is declared and executed first in the .sql file, whn I try to run the script, the compiler complains because of the missing tables or fields, therefore I am looking for some sort of trick to fool the compiler temporarilythank you |
|
|
rudesyle
Posting Yak Master
110 Posts |
Posted - 2007-06-18 : 15:24:04
|
| Nope, it will error out when you try to create it. Why not just create the empty table, and then drop and recreate when the time comes to populate it? |
 |
|
|
heze
Posting Yak Master
192 Posts |
Posted - 2007-06-18 : 15:30:22
|
| yes r, thats what ill do thanks |
|
|
|
|
|
|
views with no schema binding ?