Differences

This shows you the differences between two versions of the page.

--- sysobjects_sql [2010/04/27 22:42] – created stephen
+++ sysobjects_sql [2017/01/01 20:05] (current) – external edit 127.0.0.1
@@ Line 3: / Line 3: @@
 Code snippets that get useful information out of the sysobjects table.
-^ Sysobjects.type ^ Meaning ^
+^ Sysobjects.type ^ Meaning (SQL Server) ^ Meaning (Sybase) ^
-| C | computed column |
+| C | CHECK constraint | Computed column |
-| D | default |
+| D | Default or DEFAULT constraint | Default |
-| F | SQLJ function |
+| F | FOREIGN KEY constraint | SQLJ function |
-| L | log |
+| FN | Scalar function | |
-| N | partition condition |
+| IF | Inlined table-function | |
-| P | Transact-SQL or SQLJ procedure |
+| L | Log | Log |
-| PR | prepare objects (created by Dynamic SQL) |
+| N | | Partition condition |
-| R | rule |
+| P | Stored procedure | Transact-SQL or SQLJ procedure |
-| RI | referential constraint |
+| PK | PRIMARY KEY constraint (type is K) | |
-| S | system table |
+| PR | | Prepare objects (created by Dynamic SQL) |
-| TR | trigger |
+| R | | Rule |
-| U | user table |
+| RF | Replication filter stored procedure | |
-| V | view |
+| RI | | Referential constraint |
-| XP | extended stored procedure |
+| S | System table | System table |
+| TF | Table function | |
-Note: This is from Sybase reference info.
+| TR | Trigger | Trigger |
+| U | User table | User table |
+| V | View | View |
+| X | Extended stored procedure | |
+| XP | | Extended stored procedure |
 ===== All User Tables =====