SELECT
sps.
object_id
As
ProcedureId,sps.name
As
ProcedureName,Sss.name
As
SchemaName,(
case
when
(
SELECT
COUNT
(
*
)
FROM
sys.sysdepends
WHERE
id
=
sps.
object_id
and
resultobj
=
1
)
=
0
then
0
else
1
end
)
As
IsNeedOpenDb
FROM sys.procedures sps INNER JOIN sys.schemas Sss on Sss.schema_id = Sps.schema_id
FROM sys.procedures sps INNER JOIN sys.schemas Sss on Sss.schema_id = Sps.schema_id
SELECT
ST.
object_id
As
TableId,SS.name
As
SchemaName,ST.name
As
TableName,Sep.value
As
TableDescription
FROM
sys.tables ST
LEFT
OUTER
JOIN
sys.schemas SS
ON
SS.schema_id
=
ST.schema_id
LEFT
OUTER
JOIN
sys.extended_properties Sep
On
Sep.major_id
=
ST.
object_id
and
minor_id
=
0
SELECT
SC.Colorder As ColumnId , SC.Name As ColumnName,Sep.value As ColumnDescription, St.Name As TypeName, SC.Prec,SC.Scale,SC.Colstat,Sac.Is_Identity,SC.Iscomputed, SC.Isnullable, SC.Colorder,Sic.index_id As KeyIndex,Scs. text As DefaultValue,Scss. text As AutoValue
FROM sys.syscolumns AS SC
LEFT OUTER JOIN sys.systypes St ON (St.xtype = SC.xtype) AND (St.xUSERtype = SC.xtype)
LEFT OUTER JOIN sys.syscomments Scs On Scs.Id = SC.cdefault
LEFT OUTER JOIN sys.syscomments Scss On Scss.Id = SC.id and Scss. number = SC.colorder
LEFT OUTER JOIN sys.all_columns Sac On Sac. object_id = Sc.id and Sac.column_id = SC.Colorder
LEFT OUTER JOIN sys.extended_properties Sep On Sep.major_id = Sc.id and Sep.minor_id = SC.Colorder
LEFT OUTER JOIN sys.index_columns Sic On Sic. object_id = Sc.id and Sic.column_id = SC.Colorder
WHERE (SC.id = 表ID)