forum.venkateswarlu.net
      Register      Login
view(interview question)

3 replies to this topic

Harikrishna Sikhakolli #1
Member
108 Points
 Posted on 26 Mar 2012 12:16 PM IST can we truncate the view. 
SQL Server     927 views     Reply to this topic
Laxman B #2
Member
26 Points
 Replied on 29 Mar 2012 10:45 AM IST yes, we can but below are the limitations

You cannot use TRUNCATE TABLE on tables that:

Are referenced by a FOREIGN KEY constraint. (You can truncate a table that has a foreign key that references itself.)

Participate in an indexed view.

Are published by using transactional replication or merge replication.

For tables with one or more of these characteristics, use the DELETE statement instead.

 
Reply to this topic
Harikrishna Sikhakolli #3
Member
108 Points
 Replied on 29 Mar 2012 01:21 PM IST I can't understand your answer.
we cannot truncate view.view contain only select statement.There is no records in the view.

can we kill the image in the mirror.It is not possible .similarly we cannot truncate the view. 
Reply to this topic
Dhamodharan R #4
Member
24 Points
 Replied on 17 May 2012 07:58 AM IST Dear Hari,

Please refer this link
https://forums.oracle.com/forums/thread.jspa?threadID=1054876
Thanks & Regards
Dhamodharan R
 
Reply to this topic