-- 列举所有表
SELECT * FROM SYS.SYSOBJECTS WHERE [TYPE] = 'U'    ORDER BY [NAME]

-- 列举所有存储过程
SELECT * FROM SYS.ALL_OBJECTS WHERE [TYPE] = 'P' AND IS_MS_SHIPPED = 0 ORDER BY [NAME]


SELECT [name],system_type_id,max_length,is_nullable FROM
           sys.columns where object_id = 1733281630 ORDER BY [name]

-- 查询数据表的大小
select * FROM sys.columns where object_id = 1733281630

select * FROM sys.all_columns where object_id = 1733281630

-- 删除SP
DROP PROC

-- 删除表数据（不记录日志，速度比delete块）
TRUNCATE TABLE tablename

-- 游标简单使用
DECLARE @MyCursor CURSOR;
EXEC dbo.currency_cursor @currency_cursor = @MyCursor OUTPUT;
WHILE (@@FETCH_STATUS = 0)
BEGIN;
     FETCH NEXT FROM @MyCursor;
END;
CLOSE @MyCursor;
DEALLOCATE @MyCursor;