Class CompatibilitySchema.Object
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
sys.sysobjects (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Contains one row for each object that is created within a database, such as a constraint, default, log, rule, and stored procedure.
important
This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead. To find the equivalent system view or views, see Mapping System Tables to System Views (Transact-SQL). This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
See sys.sysobjects.
[Table(Schema = "sys", Name = "sysobjects", IsView = true)]
public class CompatibilitySchema.Object- Inheritance
-
CompatibilitySchema.Object
- Extension Methods
Properties
BaseSchemaVer
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("base_schema_ver")]
[Nullable]
public int? BaseSchemaVer { get; set; }Property Value
- int?
Cache
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("cache")]
[Nullable]
public short? Cache { get; set; }Property Value
Category
Used for publication, constraints, and identity.
[Column("category")]
[Nullable]
public int? Category { get; set; }Property Value
- int?
Crdate
Date the object was created.
[Column("crdate")]
[NotNull]
public DateTime Crdate { get; set; }Property Value
Deltrig
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("deltrig")]
[Nullable]
public int? Deltrig { get; set; }Property Value
- int?
FTCatID
Identifier of the full-text catalog for all user tables registered for full-text indexing, and 0 for all user tables that are not registered.
[Column("ftcatid")]
[Nullable]
public short? FTCatID { get; set; }Property Value
ID
Object identification number
[Column("id")]
[NotNull]
public int ID { get; set; }Property Value
Indexdel
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("indexdel")]
[Nullable]
public short? Indexdel { get; set; }Property Value
Info
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("info")]
[Nullable]
public short? Info { get; set; }Property Value
Instrig
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("instrig")]
[Nullable]
public int? Instrig { get; set; }Property Value
- int?
Name
Object name
[Column("name")]
[NotNull]
public string Name { get; set; }Property Value
ParentObj
Object identification number of the parent object. For example, the table ID if it is a trigger or constraint.
[Column("parent_obj")]
[NotNull]
public int ParentObj { get; set; }Property Value
Refdate
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("refdate")]
[NotNull]
public DateTime Refdate { get; set; }Property Value
Replinfo
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("replinfo")]
[Nullable]
public int? Replinfo { get; set; }Property Value
- int?
SchemaVer
Version number that is incremented every time the schema for a table changes. Always returns 0.
[Column("schema_ver")]
[Nullable]
public int? SchemaVer { get; set; }Property Value
- int?
Seltrig
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("seltrig")]
[Nullable]
public int? Seltrig { get; set; }Property Value
- int?
StatsSchemaVer
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("stats_schema_ver")]
[Nullable]
public int? StatsSchemaVer { get; set; }Property Value
- int?
Status
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("status")]
[Nullable]
public int? Status { get; set; }Property Value
- int?
Sysstat
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("sysstat")]
[Nullable]
public short? Sysstat { get; set; }Property Value
TypeColumn
Object type. Can be one of the following values:
AF = Aggregate function (CLR)
C = CHECK constraint
D = Default or DEFAULT constraint
F = FOREIGN KEY constraint
FN = Scalar function
FS = Assembly (CLR) scalar-function
FT = Assembly (CLR) table-valued functionIF = In-lined table-function
IT - Internal table
K = PRIMARY KEY or UNIQUE constraint
L = Log
P = Stored procedure
PC = Assembly (CLR) stored-procedure
R = Rule
RF = Replication filter stored procedure
S = System table
SN = Synonym
SQ = Service queue
TA = Assembly (CLR) DML trigger
TF = Table function
TR = SQL DML Trigger
TT = Table type
U = User table
V = View
X = Extended stored procedure
[Column("type")]
[Nullable]
public string? TypeColumn { get; set; }Property Value
UID
Schema ID of the owner of the object. For databases upgraded from an earlier version of SQL Server, the schema ID is equal to the user ID of the owner. Overflows or returns NULL if the number of users and roles exceeds 32,767.
Important *</strong>* If you use any of the following SQL Server DDL statements, you must use the sys.objects catalog view instead of sys.sysobjects.
CREATE | ALTER | DROP USER
CREATE | ALTER | DROP ROLE
CREATE | ALTER | DROP APPLICATION ROLE
CREATE SCHEMA
ALTER AUTHORIZATION ON OBJECT
[Column("uid")]
[Nullable]
public short? UID { get; set; }Property Value
Updtrig
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("updtrig")]
[Nullable]
public int? Updtrig { get; set; }Property Value
- int?
Userstat
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("userstat")]
[Nullable]
public short? Userstat { get; set; }Property Value
Version
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("version")]
[Nullable]
public int? Version { get; set; }Property Value
- int?
XType
Object type. Can be one of the following object types:
AF = Aggregate function (CLR)
C = CHECK constraint
D = Default or DEFAULT constraint
F = FOREIGN KEY constraint
L = Log
FN = Scalar function
FS = Assembly (CLR) scalar-function
FT = Assembly (CLR) table-valued function
IF = In-lined table-function
IT = Internal table
P = Stored procedure
PC = Assembly (CLR) stored-procedure
PK = PRIMARY KEY constraint (type is K)
RF = Replication filter stored procedure
S = System table
SN = Synonym
SQ = Service queue
TA = Assembly (CLR) DML trigger
TF = Table function
TR = SQL DML Trigger
TT = Table type
U = User table
UQ = UNIQUE constraint (type is K)
V = View
X = Extended stored procedure
[Column("xtype")]
[NotNull]
public string XType { get; set; }