Module ImportFrom alias Import alias identifier Assign NameStore Num ClassDef bases NameLoad body Assign NameStore Dict NameLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str Str FunctionDef arguments args NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr Str Return ListComp SubscriptLoad NameLoad Index Num comprehension NameStore Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam defaults body Expr Str Expr Call AttributeLoad NameLoad attr Str TupleLoad Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr NameLoad NameLoad Return SubscriptLoad SubscriptLoad Call AttributeLoad NameLoad attr Index Num Index Num decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam defaults NameLoad body Expr Str Assign NameStore ListComp ListLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num NameLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num comprehension NameStore Call AttributeLoad NameLoad attr keyword NameLoad Assign NameStore ListLoad For NameStore NameLoad body If BoolOpAnd NameLoad Call AttributeLoad NameLoad attr NameLoad NameLoad SubscriptLoad NameLoad Index Num body Assign SubscriptStore NameLoad Index Num NameLoad If BoolOpAnd CompareEq SubscriptLoad NameLoad Index Num AttributeLoad NameLoad attr CompareLt SubscriptLoad NameLoad Index Num Num body Assign SubscriptStore NameLoad Index Num AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str Return Call NameLoad ListComp TupleLoad SubscriptLoad NameLoad Index Num NameLoad comprehension TupleStore NameStore NameStore Call NameLoad Call AttributeLoad NameLoad attr NameLoad NameLoad keyword NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str Assign NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad Assign NameStore Str Expr Call AttributeLoad NameLoad attr NameLoad TupleLoad NameLoad Return Call NameLoad ListComp TupleLoad SubscriptLoad NameLoad Index SubscriptLoad NameLoad Index Num TupleLoad SubscriptLoad Call AttributeLoad NameLoad attr NameLoad SubscriptLoad NameLoad Index Num Index SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num comprehension NameStore Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str Assign NameStore Str Assign NameStore ListComp SubscriptLoad NameLoad Index Num comprehension NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad keyword NameLoad Assign TupleStore NameStore NameStore TupleLoad Dict Dict Expr Call AttributeLoad NameLoad attr NameLoad TupleLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr If NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad Assign NameStore Str If CompareGtE AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Num body Expr Call AttributeLoad NameLoad attr NameLoad TupleLoad NameLoad For NameStore ListComp SubscriptLoad NameLoad Index Num comprehension NameStore Call AttributeLoad NameLoad attr body If CompareNotIn NameLoad NameLoad body Assign SubscriptStore NameLoad Index NameLoad Str For NameStore NameLoad body Assign NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad Assign SubscriptStore NameLoad Index NameLoad Call NameLoad keyword CompareEq NameLoad Str keyword CompareEq NameLoad Str keyword CompareEq NameLoad Str Return NameLoad decorator_list decorator_list
N/A django.db.backends BaseDatabaseIntrospection N/A pyodbc Database N/A SQL_AUTOFIELD -777555 DatabaseIntrospection N/A BaseDatabaseIntrospection N/A N/A data_types_reverse N/A SQL_AUTOFIELD N/A Database SQL_BIGINT N/A Database SQL_BIT N/A Database SQL_CHAR N/A Database SQL_DECIMAL N/A Database SQL_DOUBLE N/A Database SQL_FLOAT N/A Database SQL_GUID N/A Database SQL_INTEGER N/A Database SQL_NUMERIC N/A Database SQL_REAL N/A Database SQL_SMALLINT N/A Database SQL_TINYINT N/A Database SQL_TYPE_DATE N/A Database SQL_TYPE_TIME N/A Database SQL_TYPE_TIMESTAMP N/A Database SQL_VARCHAR N/A Database SQL_WCHAR N/A Database SQL_WLONGVARCHAR N/A Database SQL_WVARCHAR AutoField IntegerField BooleanField CharField DecimalField FloatField FloatField TextField IntegerField DecimalField FloatField SmallIntegerField SmallIntegerField DateField TimeField DateTimeField TextField CharField TextField TextField get_table_list N/A N/A self cursor N/A N/A N/A 
        Returns a list of table names in the current database.
         N/A N/A N/A cursor execute SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' N/A N/A N/A row N/A 0 N/A row N/A N/A cursor fetchall N/A _is_auto_field N/A N/A self cursor table_name column_name N/A N/A N/A 
        Checks whether column is Identity
         N/A N/A N/A cursor execute SELECT COLUMNPROPERTY(OBJECT_ID(%s), %s, 'IsIdentity') N/A N/A N/A N/A N/A self connection ops quote_name table_name column_name N/A N/A N/A N/A N/A cursor fetchall N/A 0 N/A 0 N/A get_table_description N/A N/A self cursor table_name identity_check N/A True N/A N/A Returns a description of the table, with DB-API cursor.description interface.

        The 'auto_check' parameter has been added to the function argspec.
        If set to True, the function will check each of the table's fields for the
        IDENTITY property (the IDENTITY property is the MSSQL equivalent to an AutoField).

        When a field is found with an IDENTITY property, it is given a custom field number
        of SQL_AUTOFIELD, which maps to the 'AutoField' value in the DATA_TYPES_REVERSE dict.
         N/A columns N/A N/A N/A c N/A 3 N/A c N/A 4 None N/A c N/A 6 N/A c N/A 6 N/A c N/A 8 N/A c N/A 10 N/A c N/A N/A cursor columns table table_name N/A items N/A N/A column columns N/A N/A N/A identity_check N/A N/A self _is_auto_field cursor table_name N/A column N/A 0 N/A N/A N/A column N/A 1 SQL_AUTOFIELD N/A N/A N/A N/A column N/A 1 N/A Database SQL_WVARCHAR N/A N/A column N/A 3 4000 N/A N/A N/A column N/A 1 N/A Database SQL_WCHAR N/A N/A N/A items append column N/A items N/A _name_to_index N/A N/A self cursor table_name N/A N/A N/A 
        Returns a dictionary of {field_name: field_index} for the given table.
        Indexes are 0-based.
         N/A N/A dict N/A N/A N/A d N/A 0 i N/A N/A i d N/A enumerate N/A N/A self get_table_description cursor table_name identity_check False N/A get_relations N/A N/A self cursor table_name N/A N/A N/A 
        Returns a dictionary of {field_index: (field_index_other_table, other_table)}
        representing all relationships to the given table. Indexes are 0-based.
         N/A table_index N/A N/A self _name_to_index cursor table_name N/A sql 
SELECT e.COLUMN_NAME AS column_name,
  c.TABLE_NAME AS referenced_table_name,
  d.COLUMN_NAME AS referenced_column_name
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS a
INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS b
  ON a.CONSTRAINT_NAME = b.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE AS c
  ON b.UNIQUE_CONSTRAINT_NAME = c.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE AS d
  ON c.CONSTRAINT_NAME = d.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE AS e
  ON a.CONSTRAINT_NAME = e.CONSTRAINT_NAME
WHERE a.TABLE_NAME = %s AND a.CONSTRAINT_TYPE = 'FOREIGN KEY' N/A N/A N/A cursor execute sql N/A table_name N/A N/A dict N/A N/A N/A table_index N/A N/A item N/A 0 N/A N/A N/A N/A self _name_to_index cursor N/A item N/A 1 N/A N/A item N/A 2 N/A item N/A 1 N/A item N/A N/A cursor fetchall N/A get_indexes N/A N/A self cursor table_name N/A N/A N/A 
        Returns a dictionary of fieldname -> infodict for the given table,
        where each infodict is in the format:
            {'primary_key': boolean representing whether it's the primary key,
             'unique': boolean representing whether it's a unique index,
             'db_index': boolean representing whether it's a non-unique index}
         N/A pk_uk_sql 
SELECT b.COLUMN_NAME, a.CONSTRAINT_TYPE
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS a
INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE AS b
  ON a.CONSTRAINT_NAME = b.CONSTRAINT_NAME AND a.TABLE_NAME = b.TABLE_NAME
WHERE a.TABLE_NAME = %s AND (CONSTRAINT_TYPE = 'PRIMARY KEY' OR CONSTRAINT_TYPE = 'UNIQUE') N/A field_names N/A N/A item N/A 0 N/A item N/A N/A self get_table_description cursor table_name identity_check False N/A N/A indexes results N/A N/A N/A N/A N/A N/A cursor execute pk_uk_sql N/A table_name N/A data N/A N/A cursor fetchall N/A data N/A N/A N/A N/A results update data N/A ix_sql 
SELECT DISTINCT c.name
FROM sys.columns c
INNER JOIN sys.index_columns ic
  ON ic.object_id = c.object_id AND ic.column_id = c.column_id
INNER JOIN sys.indexes ix
  ON ix.object_id = ic.object_id AND ix.index_id = ic.index_id
INNER JOIN sys.tables t
  ON t.object_id = ix.object_id
WHERE ix.object_id IN (
  SELECT ix.object_id
  FROM sys.indexes ix
  GROUP BY ix.object_id, ix.index_id
  HAVING count(1) = 1)
AND ix.is_primary_key = 0
AND ix.is_unique_constraint = 0
AND t.name = %s N/A N/A N/A N/A N/A self connection ops sql_server_ver 2005 N/A N/A N/A N/A cursor execute ix_sql N/A table_name N/A column N/A N/A r N/A 0 N/A r N/A N/A cursor fetchall N/A N/A N/A column results N/A N/A N/A results N/A column IX N/A field field_names N/A N/A val N/A N/A results get field None N/A N/A indexes N/A field N/A dict primary_key N/A val PRIMARY KEY unique N/A val UNIQUE db_index N/A val IX N/A indexes N/A N/A