1、Sel ect * From {订单} Where 实际的主键列名 Is Null
2、Sel ect * From {订单} Where 1=0
你可以动态生成一个临时表,即可获取表结构。
Dim cmd As new SQLCommandcmd.CommandText = "Sel ect * From {表A} Where [_Identify] Is null"cmd.CDim dt As DataTable = cmd.ExecuteReaderFor Each dc As DataCol In dt.DataCols output.show(dc.name)Next