SQL DATA TYPE FOR AN ICOLLECTIONS CODE

YES if the column is a column set column. NO if the column does not have FILESTREAM attribute. YES if the column has FILESTREAM attribute. These columns are not supported in earlier versions of the. NET Framework version 3.5 SP1 and SQL Server 2008, the following columns have been added to the Columns schema collection to support new spatial types, filestream and sparse columns. Otherwise, this column is NULL.Д«eginning with the.

Returns master, indicating the database in which the collation is defined, if the column is character data or text data type. Returns the unique name for the character set if this column is character data or text data type. Returns master, indicating the database in which the character set is located, if the column is character data or text data type.

SQL DATA TYPE FOR AN ICOLLECTIONS CODE

Subtype code for datetime and SQL-92 interval data types. Scale of approximate numeric data, exact numeric data, integer data, or monetary data. Precision radix of approximate numeric data, exact numeric data, integer data, or monetary data. Precision of approximate numeric data, exact numeric data, integer data, or monetary data. Maximum length, in bytes, for binary data, character data, or text and image data.

Maximum length, in characters, for binary data, character data, or text and image data. If this column allows NULL, this column returns YES. Precision in fractional seconds if the parameter type is datetime or smalldatetime. If not one of the character types, returns NULL. Name of the character set of the parameter. If not one of the character types, returns NULL.Д¬atalog name of the character set of the parameter. Otherwise, returns NULL.Д¬atalog name of the collation of the parameter. Maximum length, in bytes, for binary or character data types. Maximum length in characters for binary or character data types. NULL if this corresponds to the return value of a function. Returns YES if indicates result of the procedure that is a function. Returns IN if an input parameter, OUT if an output parameter, and INOUT if an input/output parameter. For the return value of a procedure, this is a 0. Ordinal position of the parameter starting at 1. Name of the procedure for which this parameter is a part of. Schema that contains the procedure for which this parameter is part of. The last time the procedure was modified.Д¬atalog name of the procedure for which this is a parameter. Returns PROCEDURE for stored procedures and FUNCTION for functions. Schema that contains the stored procedure.

The type of the index will be one of the following: - HEAP - CLUSTERED - NONCLUSTERED - XML - SPATIALД¬olumn name the index is associated with. NET Framework version 3.5 SP1 and SQL Server 2008, the following columns have been added to the Indexes schema collection to support new spatial types, filestream and sparse columns. Schema that contains the table the index is associated with.Д«eginning with the. Specifies whether the constraint is initially deferrable. Specifies whether the constraint is deferrable. This will return a DataTable with a list of the supported schema collections, the number of restrictions that they each support, and the number of identifier parts that they use. To determine the list of supported schema collections, call the GetSchema method with no arguments, or with the schema collection name 'MetaDataCollections'. The schema collections vary slightly by the version of SQL Server you are using. NET Framework Data Provider for SQL Server supports additional schema collections in addition to the common schema collections.

Sql data type for an icollections