MetaDataCollections 0 0 DataTable MetaDataCollections DataSourceInformation 0 0 DataTable DataSourceInformation DataTypes 0 0 PrepareCollection Restrictions 0 0 DataTable Restrictions ReservedWords 0 0 DataTable ReservedWords MyContactInformation 0 0 DataTable MyContactInformation Users 1 1 SQLCommand select uid, name as user_name, createdate, updatedate from sysusers where (name = @Name or (@Name is null)) Databases 1 1 SQLCommand select name as database_name, dbid, crdate as create_date from master..sysdatabases where (name = @Name or (@Name is null)) Tables 4 3 SQLCommand select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE from INFORMATION_SCHEMA.TABLES where (TABLE_CATALOG = @Catalog or (@Catalog is null)) and (TABLE_SCHEMA = @Owner or (@Owner is null)) and (TABLE_NAME = @Name or (@Name is null)) and (TABLE_TYPE = @TableType or (@TableType is null)) Columns 4 4 SQLCommand select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION, COLUMN_DEFAULT, IS_NULLABLE, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH, NUMERIC_PRECISION, NUMERIC_PRECISION_RADIX, NUMERIC_SCALE, DATETIME_PRECISION, CHARACTER_SET_CATALOG, CHARACTER_SET_SCHEMA, CHARACTER_SET_NAME, COLLATION_CATALOG from INFORMATION_SCHEMA.COLUMNS where (TABLE_CATALOG = @Catalog or (@Catalog is null)) and (TABLE_SCHEMA = @Owner or (@Owner is null)) and (TABLE_NAME = @Table or (@Table is null)) and (COLUMN_NAME = @Column or (@Column is null)) order by TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME Views 3 3 SQLCommand select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, CHECK_OPTION, IS_UPDATABLE from INFORMATION_SCHEMA.VIEWS where (TABLE_CATALOG = @Catalog or (@Catalog is null)) and (TABLE_SCHEMA = @Owner or (@Owner is null)) and (TABLE_NAME = @Table or (@Table is null)) order by TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME 08.00.000.0 ViewColumns 4 4 SQLCommand select VIEW_CATALOG, VIEW_SCHEMA, VIEW_NAME, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME from INFORMATION_SCHEMA.VIEW_COLUMN_USAGE where (VIEW_CATALOG = @Catalog or (@Catalog is null)) and (VIEW_SCHEMA = @Owner or (@Owner is null)) and (VIEW_NAME = @Table or (@Table is null)) and (COLUMN_NAME = @Column or (@Column is null)) order by VIEW_CATALOG, VIEW_SCHEMA, VIEW_NAME 08.00.000.0 ProcedureParameters 4 1 SQLCommand select SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME, ORDINAL_POSITION, PARAMETER_MODE, IS_RESULT, AS_LOCATOR, PARAMETER_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH, COLLATION_CATALOG, COLLATION_SCHEMA, COLLATION_NAME, CHARACTER_SET_CATALOG, CHARACTER_SET_SCHEMA, CHARACTER_SET_NAME, NUMERIC_PRECISION, NUMERIC_PRECISION_RADIX, NUMERIC_SCALE, DATETIME_PRECISION, INTERVAL_TYPE, INTERVAL_PRECISION from INFORMATION_SCHEMA.PARAMETERS where (SPECIFIC_CATALOG = @Catalog or (@Catalog is null)) and (SPECIFIC_SCHEMA = @Owner or (@Owner is null)) and (SPECIFIC_NAME = @Name or (@Name is null)) and (PARAMETER_NAME = @Parameter or (@Parameter is null)) order by SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME, PARAMETER_NAME 08.00.0000 Procedures 4 3 SQLCommand select SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME, ROUTINE_CATALOG, ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_TYPE, CREATED, LAST_ALTERED from INFORMATION_SCHEMA.ROUTINES where (SPECIFIC_CATALOG = @Catalog or (@Catalog is null)) and (SPECIFIC_SCHEMA = @Owner or (@Owner is null)) and (SPECIFIC_NAME = @Name or (@Name is null)) and (ROUTINE_TYPE = @Type or (@Type is null)) order by SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME 08.00.0000 ForeignKeys 4 3 SQLCommand select CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, CONSTRAINT_TYPE, IS_DEFERRABLE, INITIALLY_DEFERRED from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where (CONSTRAINT_CATALOG = @Catalog or (@Catalog is null)) and (CONSTRAINT_SCHEMA = @Owner or (@Owner is null)) and (TABLE_NAME = @Table or (@Table is null)) and (CONSTRAINT_NAME = @Name or (@Name is null)) and CONSTRAINT_TYPE = 'FOREIGN KEY' order by CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME IndexColumns 5 4 SQLCommand select distinct db_Name() as constraint_catalog, constraint_schema = user_name(o.uid), constraint_name = x.name, table_catalog = db_name(), table_schema = user_name(o.uid), table_name = o.name, column_name = c.name, ordinal_position = convert(int, xk.keyno), KeyType = c.xtype, index_name = x.name from sysobjects o, sysindexes x, syscolumns c, sysindexkeys xk where o.type in ('U') and x.id = o.id and o.id = c.id and o.id = xk.id and x.indid = xk.indid and c.colid = xk.colid and xk.keyno < = x.keycnt and permissions(o.id, c.name) <> 0 and (db_name() = @Catalog or (@Catalog is null)) and (user_name()= @Owner or (@Owner is null)) and (o.name = @Table or (@Table is null)) and (x.name = @ConstraintName or (@ConstraintName is null)) and (c.name = @Column or (@Column is null)) order by table_name, index_name Indexes 4 3 SQLCommand select distinct db_Name() as constraint_catalog, constraint_schema = user_name(o.uid), constraint_name = x.name, table_catalog = db_name(), table_schema = user_name(o.uid), table_name = o.name, index_name = x.name from sysobjects o, sysindexes x, sysindexkeys xk where o.type in ('U') and x.id = o.id and o.id = xk.id and x.indid = xk.indid and xk.keyno < = x.keycnt and (db_name() = @Catalog or (@Catalog is null)) and (user_name()= @Owner or (@Owner is null)) and (o.name = @Table or (@Table is null)) and (x.name = @Name or (@Name is null)) order by table_name, index_name UserDefinedTypes 2 1 SQLCommand select assemblies.name as assembly_name, types.assembly_class as udt_name, ASSEMBLYPROPERTY(assemblies.name, 'VersionMajor') as version_major, ASSEMBLYPROPERTY(assemblies.name, 'VersionMinor') as version_minor, ASSEMBLYPROPERTY(assemblies.name, 'VersionBuild') as version_build, ASSEMBLYPROPERTY(assemblies.name, 'VersionRevision') as version_revision, ASSEMBLYPROPERTY(assemblies.name, 'CultureInfo') as culture_info, ASSEMBLYPROPERTY(assemblies.name, 'PublicKey') as public_key, is_fixed_length, max_length, Create_Date, Permission_set_desc from sys.assemblies as assemblies join sys.assembly_types as types on assemblies.assembly_id = types.assembly_id where (assemblies.name = @AssemblyName or (@AssemblyName is null)) and (types.assembly_class = @UDTName or (@UDTName is null)) 09.00.0000 PrimaryKeys 4 3 SQLCommand select CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, CONSTRAINT_TYPE, IS_DEFERRABLE, INITIALLY_DEFERRED from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where (CONSTRAINT_CATALOG = @Catalog or (@Catalog is null)) and (CONSTRAINT_SCHEMA = @Owner or (@Owner is null)) and (TABLE_NAME = @Table or (@Table is null)) and (CONSTRAINT_NAME = @Name or (@Name is null)) and CONSTRAINT_TYPE = 'PRIMARY KEY' order by CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME Users User_Name @Name name 1 Databases Name @Name Name 1 Tables Catalog @Catalog TABLE_CATALOG 1 Tables Owner @Owner TABLE_SCHEMA 2 Tables Table @Name TABLE_NAME 3 Tables TableType @TableType TABLE_TYPE 4 Columns Catalog @Catalog TABLE_CATALOG 1 Columns Owner @Owner TABLE_SCHEMA 2 Columns Table @Table TABLE_NAME 3 Columns Column @Column COLUMN_NAME 4 Views Catalog @Catalog TABLE_CATALOG 1 08.00.000.0 Views Owner @Owner TABLE_SCHEMA 2 08.00.000.0 Views Table @Table TABLE_NAME 3 08.00.000.0 ViewColumns Catalog @Catalog VIEW_CATALOG 1 08.00.000.0 ViewColumns Owner @Owner VIEW_SCHEMA 2 08.00.000.0 ViewColumns Table @Table VIEW_NAME 3 08.00.000.0 ViewColumns Column @Column COLUMN_NAME 4 08.00.000.0 ProcedureParameters Catalog @Catalog SPECIFIC_CATALOG 1 08.00.0000 ProcedureParameters Owner @Owner SPECIFIC_SCHEMA 2 08.00.0000 ProcedureParameters Name @Name SPECIFIC_NAME 3 08.00.0000 ProcedureParameters Parameter @Parameter PARAMETER_NAME 4 08.00.0000 Procedures Catalog @Catalog SPECIFIC_CATALOG 1 08.00.0000 Procedures Owner @Owner SPECIFIC_SCHEMA 2 08.00.0000 Procedures Name @Name SPECIFIC_NAME 3 08.00.0000 Procedures Type @Type ROUTINE_TYPE 4 08.00.0000 IndexColumns Catalog @Catalog db_name() 1 IndexColumns Owner @Owner user_name() 2 IndexColumns Table @Table o.name 3 IndexColumns ConstraintName @ConstraintName x.name 4 IndexColumns Column @Column c.name 5 Indexes Catalog @Catalog db_name() 1 Indexes Owner @Owner user_name() 2 Indexes Table @Table o.name 3 Indexes Name @Name x.name 4 UserDefinedTypes assembly_name @AssemblyName assemblies.name 1 09.00.000.0 UserDefinedTypes udt_name @UDTName types.assembly_class 2 09.00.000.0 ForeignKeys Catalog @Catalog CONSTRAINT_CATALOG 1 ForeignKeys Owner @Owner CONSTRAINT_SCHEMA 2 ForeignKeys Table @Table TABLE_NAME 3 ForeignKeys Name @Name CONSTRAINT_NAME 4 PrimaryKeys Catalog @Catalog CONSTRAINT_CATALOG 1 PrimaryKeys Owner @Owner CONSTRAINT_SCHEMA 2 PrimaryKeys Table @Table TABLE_NAME 3 PrimaryKeys Name @Name CONSTRAINT_NAME 4 \. Microsoft SQL Server 2 (^\[\p{Lo}\p{Lu}\p{Ll}_@#][\p{Lo}\p{Lu}\p{Ll}\p{Nd}@$#_]*$)|(^\[[^\]\0]|\]\]+\]$)|(^\"[^\"\0]|\"\"+\"$) 1 false {0} @[\p{Lo}\p{Lu}\p{Ll}\p{Lm}_@#][\p{Lo}\p{Lu}\p{Ll}\p{Lm}\p{Nd}\uff3f_@#\$]*(?=\s+|$) 128 ^[\p{Lo}\p{Lu}\p{Ll}\p{Lm}_@#][\p{Lo}\p{Lu}\p{Ll}\p{Lm}\p{Nd}\uff3f_@#\$]*(?=\s+|$) (([^\[]|\]\])*) 1 ; '(([^']|'')*)' 15 Carl Perry ADO.NET Data Programability Microsft Corporation smallint 16 5 smallint System.Int16 true true false false true true false true true false false int 8 10 int System.Int32 true true false false true true false true true false false real 13 7 real System.Single false true false false true false false true true false false float 6 53 float({0}) number of bits used to store the mantissa System.Double false true false false true false false true true false false money 9 19 money System.Decimal false false false false true true false true true false false smallmoney 17 10 smallmoney System.Decimal false false false false true true false true true false false bit 2 1 bit System.Boolean false false false false true false false true true false tinyint 20 3 tinyint System.SByte true true false false true true false true true false true bigint 0 19 bigint System.Int64 true true false false true true false true true false false varbinary 21 8000 varbinary({0}) max length System.Byte[] false true false false false false false true true false 08.99.999.9 0x timestamp 19 8 timestamp System.Byte[] false false false true true false false false true false 0x binary 1 8000 binary({0}) length System.Byte[] false true false false true false false true true false 0x image 7 2147483647 image System.Byte[] false true false false false false true true false false 0x char 3 8000 char length System.String false true false false true false false true true true 08.99.999.9 ' ' text 18 2147483647 text System.String false true false false false false true true false true ' ' varchar 22 8000 varchar({0}) max length System.String false true false false false false false true true true 08.99.999.9 ' ' nchar 10 4000 nchar({0}) length System.String false true false false true false false true true true 08.99.999.9 N' ' ntext 11 1073741823 ntext System.String false true false false false false true true false true N' ' nvarchar 12 4000 nvarchar({0}) max length System.String false true false false false false false true true true 08.99.999.9 N' ' decimal 5 38 decimal({0}, {1}) precision,scale System.Decimal true true false false true false false true true false false 38 0 numeric 5 38 numeric({0}, {1}) precision,scale System.Decimal true true false false true false false true true false false 38 0 datetime 4 23 datetime System.DateTime false true false false true false false true true true {ts ' '} smalldatetime 15 16 smalldatetime System.DateTime false true false false true false false true true true {ts ' '} sql_variant 23 sql_variant System.Object false true false false false false false true true false false xml 25 2147483647 xml System.String false false false false false false true true false false 09.00.000.0 false varchar 22 2147483647 varchar({0}) max length System.String false true false false false false false true true true 09.00.000.0 ' ' char 3 2147483647 char({0}) length System.String false true false false true false false true true true 09.00.000.0 ' ' nchar 10 1073741823 nchar({0}) length System.String false true false false true false false true true true 09.00.000.0 N' ' nvarchar 12 1073741823 nvarchar({0}) max length System.String false true false false false false false true true true 09.00.000.0 N' ' varbinary 21 1073741823 varbinary({0}) max length System.Byte[] false true false false false false false true true false 09.00.000.0 0x uniqueidentifier 14 16 uniqueidentifier System.Guid false true false false true false false true true false ' ' ADD EXCEPT PERCENT ALL EXEC PLAN ALTER EXECUTE PRECISION AND EXISTS PRIMARY ANY EXIT PRINT AS FETCH PROC ASC FILE PROCEDURE AUTHORIZATION FILLFACTOR PUBLIC BACKUP FOR RAISERROR BEGIN FOREIGN READ BETWEEN FREETEXT READTEXT BREAK FREETEXTTABLE RECONFIGURE BROWSE FROM REFERENCES BULK FULL REPLICATION BY FUNCTION RESTORE CASCADE GOTO RESTRICT CASE GRANT RETURN CHECK GROUP REVOKE CHECKPOINT HAVING RIGHT CLOSE HOLDLOCK ROLLBACK CLUSTERED IDENTITY ROWCOUNT COALESCE IDENTITY_INSERT ROWGUIDCOL COLLATE IDENTITYCOL RULE COLUMN IF SAVE COMMIT IN SCHEMA COMPUTE INDEX SELECT CONSTRAINT INNER SESSION_USER CONTAINS INSERT SET CONTAINSTABLE INTERSECT SETUSER CONTINUE INTO SHUTDOWN CONVERT IS SOME CREATE JOIN STATISTICS CROSS KEY SYSTEM_USER CURRENT KILL TABLE CURRENT_DATE LEFT TEXTSIZE CURRENT_TIME LIKE THEN CURRENT_TIMESTAMP LINENO TO CURRENT_USER LOAD TOP CURSOR NATIONAL TRAN DATABASE NOCHECK TRANSACTION DBCC NONCLUSTERED TRIGGER DEALLOCATE NOT TRUNCATE DECLARE NULL TSEQUAL DEFAULT NULLIF UNION DELETE OF UNIQUE DENY OFF UPDATE DESC OFFSETS UPDATETEXT DISK ON USE DISTINCT OPEN USER DISTRIBUTED OPENDATASOURCE VALUES DOUBLE OPENQUERY VARYING DROP OPENROWSET VIEW DUMMY OPENXML WAITFOR DUMP OPTION WHEN ELSE OR WHERE END ORDER WHILE ERRLVL OUTER WITH ESCAPE OVER WRITETEXT ABSOLUTE FOUND PRESERVE ACTION FREE PRIOR ADMIN GENERAL PRIVILEGES AFTER GET READS AGGREGATE GLOBAL REAL ALIAS GO RECURSIVE ALLOCATE GROUPING REF ARE HOST REFERENCING ARRAY HOUR RELATIVE ASSERTION IGNORE RESULT AT IMMEDIATE RETURNS BEFORE INDICATOR ROLE BINARY INITIALIZE ROLLUP BIT INITIALLY ROUTINE BLOB INOUT ROW BOOLEAN INPUT ROWS BOTH INT SAVEPOINT BREADTH INTEGER SCROLL CALL INTERVAL SCOPE CASCADED ISOLATION SEARCH CAST ITERATE SECOND CATALOG LANGUAGE SECTION CHAR LARGE SEQUENCE CHARACTER LAST SESSION CLASS LATERAL SETS CLOB LEADING SIZE COLLATION LESS SMALLINT COMPLETION LEVEL SPACE CONNECT LIMIT SPECIFIC CONNECTION LOCAL SPECIFICTYPE CONSTRAINTS LOCALTIME SQL CONSTRUCTOR LOCALTIMESTAMP SQLEXCEPTION CORRESPONDING LOCATOR SQLSTATE CUBE MAP SQLWARNING CURRENT_PATH MATCH START CURRENT_ROLE MINUTE STATE CYCLE MODIFIES STATEMENT DATA MODIFY STATIC DATE MODULE STRUCTURE DAY MONTH TEMPORARY DEC NAMES TERMINATE DECIMAL NATURAL THAN DEFERRABLE NCHAR TIME DEFERRED NCLOB TIMESTAMP DEPTH NEW TIMEZONE_HOUR DEREF NEXT TIMEZONE_MINUTE DESCRIBE NO TRAILING DESCRIPTOR NONE TRANSLATION DESTROY NUMERIC TREAT DESTRUCTOR OBJECT TRUE DETERMINISTIC OLD UNDER DICTIONARY ONLY UNKNOWN DIAGNOSTICS OPERATION UNNEST DISCONNECT ORDINALITY USAGE DOMAIN OUT USING DYNAMIC OUTPUT VALUE EACH PAD VARCHAR END-EXEC PARAMETER VARIABLE EQUALS PARAMETERS WHENEVER EVERY PARTIAL WITHOUT EXCEPTION PATH WORK EXTERNAL POSTFIX WRITE FALSE PREFIX YEAR FIRST PREORDER ZONE FLOAT PREPARE ADA AVG BIT_LENGTH CHAR_LENGTH CHARACTER_LENGTH COUNT EXTRACT FORTRAN INCLUDE INSENSITIVE LOWER MAX MIN OCTET_LENGTH OVERLAPS PASCAL POSITION SQLCA SQLCODE SQLERROR SUBSTRING SUM TRANSLATE TRIM UPPER