更改某个表exec sp_changeobjectowner ''tablename'',''dbo''存储更改全部表CREATE PROCEDURE dbo.User_ChangeObjectOwnerBatch@OldOwner as NVARCHAR(128),@NewOwner as NVARCHAR(128)ASDECLARE @Name as NVARCHAR(128)DECLARE @Owner as NVARCHAR(128)DECLARE @OwnerName as NVARCHA

SQL语句：表：select * from cat;select * from tab;select table_name from user_tables;视图：select text from user_views where view_name=upper(''view_name'');索引：select index_name,table_owner,table_name,tablespace_name,status from user_indexes