sqlserver查询所有表名、字段名、类型、长度和存储过程、视图的创建语句

-select * from sysobjects 

--select * from syscolumns

--select * from syscomments

--select * from systypes