Class CompatibilitySchema.DataContext
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
public class CompatibilitySchema.DataContext- Inheritance
-
CompatibilitySchema.DataContext
- Extension Methods
Constructors
DataContext(IDataContext)
public DataContext(IDataContext dataContext)Parameters
dataContextIDataContext
Properties
AltFiles
sys.sysaltfiles (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Under special circumstances, contains rows corresponding to the files in a database.
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.sysaltfiles.
public ITable<CompatibilitySchema.AltFile> AltFiles { get; }Property Value
CacheObjects
sys.syscacheobjects (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains information about how the cache is used.
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.syscacheobjects.
public ITable<CompatibilitySchema.CacheObject> CacheObjects { get; }Property Value
Charsets
sys.syscharsets (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Contains one row for each character set and sort order defined for use by the SQL Server Database Engine. One of the sort orders is marked in sysconfigures as the default sort order. This is the only one actually being used.
See sys.syscharsets.
public ITable<CompatibilitySchema.Charset> Charsets { get; }Property Value
Columns
sys.syscolumns (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Returns one row for every column in every table and view, and a row for each parameter in a stored procedure in the database.
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.syscolumns.
public ITable<CompatibilitySchema.Column> Columns { get; }Property Value
Comments
sys.syscomments (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains entries for each view, rule, default, trigger, CHECK constraint, DEFAULT constraint, and stored procedure within the database. The text column contains the original SQL definition statements.
important
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. We recommend that you use sys.sql_modules instead. For more information, see sys.sql_modules (Transact-SQL).
See sys.syscomments.
public ITable<CompatibilitySchema.Comment> Comments { get; }Property Value
Configures
sys.sysconfigures (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains one row for each configuration option set by a user. sysconfigures contains the configuration options that are defined before the most recent startup of SQL Server, plus any dynamic configuration options set since then.
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.sysconfigures.
public ITable<CompatibilitySchema.Configure> Configures { get; }Property Value
Constraints
sys.sysconstraints (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains mappings of constraints to the objects that own the constraints within the database.
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.sysconstraints.
public ITable<CompatibilitySchema.Constraint> Constraints { get; }Property Value
CurConfigs
sys.syscurconfigs (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains an entry for each current configuration option. Also, this view contains four entries that describe the configuration structure. syscurconfigs is built dynamically when queried by a user. For more information, see sys.sysconfigures (Transact-SQL).
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.syscurconfigs.
public ITable<CompatibilitySchema.CurConfig> CurConfigs { get; }Property Value
Databases
sys.sysdatabases (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 database in an instance of Microsoft SQL Server. When SQL Server is first installed, sysdatabases contains entries for the master, model, msdb, and tempdb databases.
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.sysdatabases.
public ITable<CompatibilitySchema.Database> Databases { get; }Property Value
Depends
sys.sysdepends (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains dependency information between objects (views, procedures, and triggers) in the database, and the objects (tables, views, and procedures) that are contained in their definition.
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.sysdepends.
public ITable<CompatibilitySchema.Depend> Depends { get; }Property Value
Devices
sys.sysdevices (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains one row for each disk backup file, tape backup file, and database file.
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.sysdevices.
public ITable<CompatibilitySchema.Device> Devices { get; }Property Value
FileGroups
sys.sysfilegroups (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains one row for each file group in a database. There is at least one entry in this table that is for the primary file group.
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.sysfilegroups.
public ITable<CompatibilitySchema.FileGroup> FileGroups { get; }Property Value
Files
sys.sysfiles (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains one row for each file in a database.
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.sysfiles.
public ITable<CompatibilitySchema.File> Files { get; }Property Value
ForeignKeys
sys.sysforeignkeys (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains information about the FOREIGN KEY constraints that are in the definitions of tables in the database.
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.sysforeignkeys.
public ITable<CompatibilitySchema.ForeignKey> ForeignKeys { get; }Property Value
FullTextCatalogs
sys.sysfulltextcatalogs (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Managed Instance √ Analytics Platform System (PDW)
Contains information about the full-text catalogs.
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.
public ITable<CompatibilitySchema.FullTextCatalog> FullTextCatalogs { get; }Property Value
IndexKeys
sys.sysindexkeys (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains information about the keys or columns in an index of the database.
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.sysindexkeys.
public ITable<CompatibilitySchema.IndexKey> IndexKeys { get; }Property Value
Indexes
sys.sysindexes (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains one row for each index and table in the current database. XML indexes are not supported in this view. Partitioned tables and indexes are not fully supported in this view; use the sys.indexes catalog view instead.
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.sysindexes.
public ITable<CompatibilitySchema.Index> Indexes { get; }Property Value
Languages
sys.syslanguages (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Contains one row for each language present in the instance of SQL Server.
See sys.syslanguages.
public ITable<CompatibilitySchema.Language> Languages { get; }Property Value
LockInfoes
sys.syslockinfo (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains information about all granted, converting, and waiting lock requests.
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.
important
This feature has changed from earlier versions of SQL Server. For more information, see Breaking Changes to Database Engine Features in SQL Server 2016.
See sys.syslockinfo.
public ITable<CompatibilitySchema.LockInfo> LockInfoes { get; }Property Value
Logins
sys.syslogins (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains one row for each login account.
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.
Applies to: SQL Server ( SQL Server 2008 through [current version](/troubleshoot/sql/general/determine-version-edition-update-level)).
See sys.syslogins.
public ITable<CompatibilitySchema.Login> Logins { get; }Property Value
Members
sys.sysmembers (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains a row for each member of a database role.
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.sysmembers.
public ITable<CompatibilitySchema.Member> Members { get; }Property Value
Messages
sys.sysmessages (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains one row for each system error or warning that can be returned by the SQL Server Database Engine. The Database Engine displays the error description on the user's screen.
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.sysmessages.
public ITable<CompatibilitySchema.Message> Messages { get; }Property Value
Objects
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.
public ITable<CompatibilitySchema.Object> Objects { get; }Property Value
OleDBUsers
sys.sysoledbusers (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
important
This SQL Server 2000 (8.x) system table is included in SQL Server as a view for backward compatibility only. We recommend that you use catalog views instead.
Contains one row for each user and password mapping for the specified linked server. sysoledbusers is stored in the master database.
See sys.sysoledbusers.
public ITable<CompatibilitySchema.OleDBUser> OleDBUsers { get; }Property Value
PerfInfoes
sys.sysperfinfo (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains a Microsoft SQL Server Database Engine representation of the internal performance counters that can be displayed through the Windows System Monitor.
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.sysperfinfo.
public ITable<CompatibilitySchema.PerfInfo> PerfInfoes { get; }Property Value
Permissions
sys.syspermissions (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains information about permissions granted and denied to users, groups, and roles in the database.
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.syspermissions.
public ITable<CompatibilitySchema.Permission> Permissions { get; }Property Value
Processes
sys.sysprocesses (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains information about processes that are running on an instance of SQL Server. These processes can be client processes or system processes. To access sysprocesses, you must be in the master database context, or you must use the master.dbo.sysprocesses three-part name.
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.sysprocesses.
public ITable<CompatibilitySchema.Process> Processes { get; }Property Value
Protects
sys.sysprotects (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains information about permissions that have been applied to security accounts in the database by using the GRANT and DENY statements.
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.sysprotects.
public ITable<CompatibilitySchema.Protect> Protects { get; }Property Value
References
sys.sysreferences (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Contains mappings of the FOREIGN KEY constraint definitions to the referenced columns within the database.
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.sysreferences.
public ITable<CompatibilitySchema.Reference> References { get; }Property Value
RemoteLogins
sys.sysremotelogins (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains one row for each remote user that is permitted to call remote stored procedures on an instance of Microsoft SQL Server.
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.sysremotelogins.
public ITable<CompatibilitySchema.RemoteLogin> RemoteLogins { get; }Property Value
Servers
sys.sysservers (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains one row for each server that an instance of SQL Server can access as an OLE DB data source.
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.sysservers.
public ITable<CompatibilitySchema.Server> Servers { get; }Property Value
Types
sys.systypes (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)
Returns one row for each system-supplied and each user-defined data type defined in the database.
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.systypes.
public ITable<CompatibilitySchema.ETable> Types { get; }Property Value
Users
sys.sysusers (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 Microsoft Windows user, Windows group, Microsoft SQL Server user, or SQL Server role in the database.
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.sysusers.
public ITable<CompatibilitySchema.User> Users { get; }