sqlserver2005查询的相关问题

Question

如何查询sqlserver2005中某个数据库下的所有表？ 如查询 model数据库下的所有表 与视图该怎么写语句？ 不要写先跳转到model库下 然后再查表和视图的语句，我要那种直接通过model数据库为条件的查询语句？ 请高手指点！

Answer 1

//查询所有用户表
select [name], [id] from model.dbo.sysobjects where [type] = 'U';
//查询所有视图
select [name], [id] from model.dbo.sysobjects where [type] = 'V';

Answer 2

来晚了..lanniao007 的正解

Answer 3

好好想想

Answer 4

- -!

Answer 5

public class BaseDao {
private String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

private String url = "jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=books";

private String userName = "sa";

private String passWord = "sa";

protected Connection con;

protected PreparedStatement pstm;

protected ResultSet rs;

// 取得数据库连接
protected void getConnection() throws Exception {
Class.forName(driver);
con = DriverManager.getConnection(url, userName, passWord);
}

// 释放资源
protected void closeAll() {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (pstm != null) {
try {
pstm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
try {
if (con != null && con.isClosed() == false) {
con.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}