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 |
|
m1k3ch3ck
Starting Member
7 Posts |
 Posted - 2012-06-08 : 06:20:45
|
do i assume correctly, that the first lines of this code make sure that there is no table called T1 ? kind of a mandatory security/quality query/statement ?furthermore: why does it say 'U' in the IF brackets ? |
|
|
waterduck
Aged Yak Warrior
982 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-08 : 12:03:39
|
quote:
Originally posted by m1k3ch3ck
do i assume correctly, that the first lines of this code make sure that there is no table called T1 ? kind of a mandatory security/quality query/statement ?furthermore: why does it say 'U' in the IF brackets ?
U means user tableyou can make use of INFORMATION_SCHEMA.TABLES view if you dont want to explicitly check on types as it would only have tables and views within it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
drop table before creating new one