我需要在数据库中查询所有存储过程的名称和架构名称。
到目前为止,这是我得到的,但是我不知道如何获取架构名称。
查询sysobjects表时,架构名称的字段名称是什么?
private DataTable GetProcedures()
{
var table = new DataTable();
string sql = "";
sql = "select name,'' as type ";
sql += " From sysobjects ";
sql += " where type = 'P' ";
sql += " and name not like 'dt_%' ";
sql += " order by name asc";
using (SqlConnection conn = new SqlConnection(cs))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(table);
}
}
}
return table;
}
也许这可以帮助您:
SELECT name AS object_name
,SCHEMA_NAME(schema_id) AS schema_name
,type_desc
,create_date
,modify_date
FROM sys.objects
WHERE type = 'P'
ORDER BY name asc;
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句