|
Schema Rowset Support (OLE DB) http://technet.microsoft.com/it-it/library/ms131488.aspx Italiano http://technet.microsoft.com/it-it/library/ms189082.aspx The following tables list schema rowsets and the restriction columns supported by the SQL Server Native Client OLE DB provider. Schema rowset Restriction columns DBSCHEMA_CATALOGS CATALOG_NAME DBSCHEMA_COLUMN_PRIVILEGES All the restrictions are supported. TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME GRANTOR GRANTEE DBSCHEMA_COLUMNS All the restrictions are supported. TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME The following additional columns are specific to SQL Server: COLUMN_LCID, which is the locale ID of the collation. COLUMN_LCID is the same value as a Windows LCID. COLUMN_COMPFLAGS defines which comparisons are supported for the collation. The data format is the same as DBPROB_FINDCOMPAREOPS. COLUMN_SORTID, which is the SQL Server sorting style for the collation. COLUMN_TDSCOLLATION, which is the SQL Server collation for the column. IS_COMPUTED, which is VARIANT_TRUE if the column is a computed column and VARIANT_FALSE otherwise. DBSCHEMA_FOREIGN_KEYS All restrictions are supported. PK_TABLE_CATALOG PK_TABLE_SCHEMA PK_TABLE_NAME FK_TABLE_CATALOG FK_TABLE_SCHEMA FK_TABLE_NAME DBSCHEMA_INDEXES Restrictions 1, 2, 3, and 5 are supported. TABLE_CATALOG TABLE_SCHEMA INDEX_NAME TABLE_NAME DBSCHEMA_PRIMARY_KEYS All restrictions are supported. TABLE_CATALOG TABLE_SCHEMA TABLE_NAME DBSCHEMA_PROCEDURE_PARAMETERS All restrictions are supported. PROCEDURE_CATALOG PROCEDURE_SCHEMA PROCEDURE_NAME PARAMETER_NAME DBSCHEMA_PROCEDURES Restrictions 1, 2, and 3 are supported. PROCEDURE_CATALOG PROCEDURE_SCHEMA PROCEDURE_NAME DBSCHEMA_PROCEDURES returns only procedures that can be executed by the current user, or for which the current user has been granted VIEW DEFINITION permission. DBSCHEMA_PROVIDER_TYPES All restrictions are supported. DATA_TYPE BEST_MATCH DBSCHEMA_SCHEMATA All restrictions are supported. CATALOG_NAME SCHEMA_NAME SCHEMA_OWNER DBSCHEMA_STATISTICS All restrictions are supported. TABLE_CATALOG TABLE_SCHEMA TABLE_NAME DBSCHEMA_TABLE_CONSTRAINTS All restrictions are supported. CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE DBSCHEMA_TABLE_PRIVILEGES All restrictions are supported. TABLE_CATALOG TABLE_SCHEMA TABLE_NAME GRANTOR GRANTEE DBSCHEMA_TABLES All restrictions are supported. TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE DBSCHEMA_TABLES_INFO All restrictions are supported. TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE SELECT TABLE_NAME, COLUMN_NAME, COLUMNPROPERTY(OBJECT_ID(TABLE_SCHEMA + '.' + TABLE_NAME), COLUMN_NAME, 'ColumnID') AS COLUMN_ID, * FROM magazzino.INFORMATION_SCHEMA.COLUMNS ; da = New SqlDataAdapter("SELECT TABLE_NAME, COLUMN_NAME, character_Maximum_Length, Data_Type, ordinal_position FROM " & Trim(TextBox1.Text) & ".INFORMATION_SCHEMA.COLUMNS Where table_Name = '" & tables.Text & "' order by TABLE_NAME, ordinal_position;", conn) |