ALTER VIEW dbo.C_company
AS
SELECT *
FROM (SELECT *
FROM indu1
UNION ALL
SELECT *
FROM indu2
UNION ALL
SELECT *
FROM indu3
UNION ALL
SELECT *
FROM indu4
UNION ALL
SELECT *
FROM indu5
UNION ALL
SELECT *
FROM indu6
UNION ALL
SELECT *
FROM indu7
UNION ALL
SELECT *
FROM indu8
UNION ALL
SELECT *
FROM indu9
UNION ALL
SELECT *
FROM indu10
UNION ALL
SELECT *
FROM indu11
UNION ALL
SELECT *
FROM indu12
UNION ALL
SELECT *
FROM indu13
UNION ALL
SELECT *
FROM indu14
UNION ALL
SELECT *
FROM indu15
UNION ALL
SELECT *
FROM indu16
UNION ALL
SELECT *
FROM indu17
UNION ALL
SELECT *
FROM indu18
UNION ALL
SELECT *
FROM indu19
UNION ALL
SELECT *
FROM indu20
UNION ALL
SELECT *
FROM indu21
UNION ALL
SELECT *
FROM indu22
UNION ALL
SELECT *
FROM indu23
UNION ALL
SELECT *
FROM indu24
UNION ALL
SELECT *
FROM indu25
UNION ALL
SELECT *
FROM indu26
UNION ALL
SELECT *
FROM indu27
UNION ALL
SELECT *
FROM indu28
UNION ALL
SELECT *
FROM indu29
UNION ALL
SELECT *
FROM indu30
UNION ALL
SELECT *
FROM indu31) Ccompany
这个是我创建的视图,怎么不可以修改呢是个怎么回事急用谢谢