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 |
|
dellgx270
Starting Member
6 Posts |
 Posted - 2009-03-07 : 05:23:46
|
| Write statements to check if the original tables still exist or have beendeleted upon deletion of the view?I don't understand.Everybody please for me a Hint.Thank you very much! |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-03-07 : 06:16:30
|
| Do you mean something like: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TableName]') AND type in (N'U'))or are you asking if tables are dropped when a view is dropped ?Jack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
sql_buddy
Starting Member
41 Posts |
Posted - 2009-03-07 : 06:36:12
|
| Deletion of View will not affect table |
|
|
|
dellgx270
Starting Member
6 Posts |
|
|
dellgx270
Starting Member
6 Posts |
Posted - 2009-03-07 : 06:48:46
|
quote:
Originally posted by sql_buddy
Deletion of View will not affect table
Thanks.I learning sql at aptech - viet nam.It is course train of India at viet nam. At that time I will need you to help!Always try for success! |
|
|
|
|
|
|
A question working with sql server 2005