用于给定oracle查询的sql server兼容查询(sql server compatible queries for given oracle queries)

用于给定oracle查询的sql server兼容查询(sql server compatible queries for given oracle queries)

我希望Microsoft SQL Server查询对应于以下Oracle查询

//get schema of a table desc tablename; //get the names of all tables select * from tab;

I want Microsoft SQL server queries corresponding to the following Oracle queries

//get schema of a table desc tablename; //get the names of all tables select * from tab;

最满意答案

您可以通过元数据表访问该信息。 检查这个链接。

INFORMATION_SCHEMA.Tables - >可让您访问表名称

INFORMATION_SCHEMA.Columns - >可以访问列名

这是另一个链接，包含目录表的完整列表。

INFORMATION_SCHEMA.CHECK_CONSTRAINTS INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE INFORMATION_SCHEMA.COLUMN_PRIVILEGES INFORMATION_SCHEMA.COLUMNS INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS INFORMATION_SCHEMA.DOMAINS INFORMATION_SCHEMA.KEY_COLUMN_USAGE INFORMATION_SCHEMA.PARAMETERS INFORMATION_SCHEMA.REFERENCIAL_CONSTRAINTS INFORMATION_SCHEMA.ROUTINE_COLUMNS INFORMATION_SCHEMA.ROUTINES INFORMATION_SCHEMA.SCHEMA_DATA INFORMATION_SCHEMA.TABLE_CONSTRAINTS INFORMATION_SCHEMA.TABLE_PRIVILEGES INFORMATION_SCHEMA.TABLES INFORMATION_SCHEMA.VIEW_COLUMN_USAGE INFORMATION_SCHEMA.VIEW_TABLE_USAGE INFORMATION_SCHEMA.VIEWS

请记住，您可能需要特殊权限才能访问这些表格/视图。

另一件您可能尝试的方法是使用ODBC，Java，.NET或任何其他编程语言或库来访问元数据信息。 他们可以通过他们的API完全访问它。

You have access to that info through metadata tables. Check this link out.

INFORMATION_SCHEMA.Tables -> gives you access to table names

INFORMATION_SCHEMA.Columns -> gives you access to column names

Here is another link with a complete list of catalog tables.

INFORMATION_SCHEMA.CHECK_CONSTRAINTS INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE INFORMATION_SCHEMA.COLUMN_PRIVILEGES INFORMATION_SCHEMA.COLUMNS INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS INFORMATION_SCHEMA.DOMAINS INFORMATION_SCHEMA.KEY_COLUMN_USAGE INFORMATION_SCHEMA.PARAMETERS INFORMATION_SCHEMA.REFERENCIAL_CONSTRAINTS INFORMATION_SCHEMA.ROUTINE_COLUMNS INFORMATION_SCHEMA.ROUTINES INFORMATION_SCHEMA.SCHEMA_DATA INFORMATION_SCHEMA.TABLE_CONSTRAINTS INFORMATION_SCHEMA.TABLE_PRIVILEGES INFORMATION_SCHEMA.TABLES INFORMATION_SCHEMA.VIEW_COLUMN_USAGE INFORMATION_SCHEMA.VIEW_TABLE_USAGE INFORMATION_SCHEMA.VIEWS

Keep in mind though, that you will probably need special permission to access those tables/views.

The other thing you might try as an alternative is using ODBC, Java, .NET or any other programming language or library to access metadata information. They have complete access to that through their APIs.