MssqlSchemaReader class

Reads table and view shapes from SQL Server's catalog views.

One query per catalog concern, not one per table: a hundred-table database costs the same seven queries as a one-table database.

INFORMATION_SCHEMA is not used. It cannot report identity columns, computed columns or triggers, which are three of the facts a generator most needs, and the driver already reads sys.* elsewhere.

Constructors

MssqlSchemaReader(MssqlConnection connection)

Properties

connection → MssqlConnection
final
hashCode int
The hash code for this object.
no setterinherited
runtimeType Type
A representation of the runtime type of the object.
no setterinherited

Methods

noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
readTable(String identifier) Future<MssqlTableSchema?>
One table by name, such as dbo.Orders or Orders (which means dbo).
readTables({Set<String> schemas = const <String>{'dbo'}, bool includeViews = true, List<String> include = const <String>['*'], List<String> exclude = const <String>[]}) Future<List<MssqlTableSchema>>
Every table, and optionally view, in schemas.
toString() String
A string representation of this object.
inherited

Operators

operator ==(Object other) bool
The equality operator.
inherited