SQLSERVER-获取表名和字段名

SQLSERVER-获取表名和字段名SQL SERVER
查看所有表名：
select name from sysobjects where type='U'
查询表的所有字段名：
Select name from syscolumns Where ID=OBJECT_ID('表名')
ACCESS
///<summary>
///取所有表名
///</summary>
///<returns></returns>
public List<string> GetTableNameList()
{
List<string> list = new List<string>();
OleDbConnection Conn = new OleDbConnection(ConnStr);
try
{
if (Conn.State == ConnectionState.Closed)
Conn.Open();
DataTable dt = Conn.GetSchema("Tables");
foreach (DataRow row in dt.Rows)
{
if (row[3].ToString() == "TABLE")
list.Add(row[2].ToString());
}
return list;
}
catch (Exception e)
{ throw e; }
finally { if (Conn.State == ConnectionState.Open) Conn.Close(); Conn.Dispose(); }
}
///<summary>
///取指定表所有字段名称
///</summary>
///<returns></returns>
public List<string> GetTableFieldNameList(string TableName)
{
List<string> list = new List<string>();
OleDbConnection Conn = new OleDbConnection(ConnStr);
try
{
if (Conn.State == ConnectionState.Closed)
Conn.Open();
using (OleDbCommand cmd = new OleDbCommand())
{
mandText = "SELECT TOP 1 * FROM [" + TableName + "]";
cmd.Connection = Conn;
OleDbDataReader dr = cmd.ExecuteReader();
for (int i = 0; i < dr.FieldCount; i++)
{
list.Add(dr.GetName(i));
}
}
return list;
}
catch (Exception e)
{ throw e; }
finally
{
if (Conn.State == ConnectionState.Open)
Conn.Close();
Conn.Dispose();
}
}
Oracle
select cname from col where tname='ZW_YINGYEZ'
select column_name from user_tab_columns where table_name='ZW_YINGYEZ'查询表字段数
select count(column_name) from user_tab_columns where table_name='表名';。