SQL Server Equivalent for Oracle System Tables/Views

Hot Topic

returning the number of rows from TOP PERCENT
IIS
Slow Startup
what components rely on SQL Authentication??
Why is TOP executed last?
How to Pass a cellset to a User-defined function
Displaying Data of a Cube over Web
Can we use DTS to import PDF and MP3 into SQL Server 200 table?
How to Speed up Database
SET NEW_BROKER statement hangs system

SQL Server

SQL Express question for parasing data from an Oracle database
Sending SQL Mail
filter expression using measures
cross table
getting last result in report builder
Create DataMiningStructure Continued
XML / XML Data Type Question
DB mirroring + load balancing
Can't export report to CSV,XMl correctly, sql 2005 reporting service
Need to do exact opposite of current trigger

SQL Server Equivalent for Oracle System Tables/Views

We are in the process of supporting two databases (Oracle 10g, SQL Server 2005) for our application.

I want to know what is the equivalent Tables/Views in SQL Server for the Oracle System tables dba_tab_comments, dba_tab_cols

Thanks in advance

Answer this question

SQL Server Equivalent for Oracle System Tables/Views

  • the emrah

    Thanks for your help. Let me try that.

  • NeoNmaN

    You could just query sys.columns or sys.all_columns from account with DBA privilege. As for the comments, you can query sys.extended_properties (with appropriate filters) or use fn_listextendedproperty table-valued function.

  • qrli

    No, its not the same concept as in Oracle. THe INFORMATION_SCHEMA Views will give you metadata information about the database. Starting in SQL 2k5 they will be secured to show only the data that the user is granted for (e.g. Tables he has minimum Select permissions on).

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
  • SQL Server Equivalent for Oracle System Tables/Views
Answer this question