Sql datatype for an icollections6/28/2023 If this column allows NULL, this column returns YES. The following table describes these columns. The only difference is that AllColumns includes column set columns that are not included in the Columns schema collection. NET Framework and SQL Server.ĪllColumns has the same restrictions and resulting DataTable schema as the Columns schema collection. AllColumns is not supported in earlier versions of the. NET Framework version 3.5 SP1 and SQL Server 2008, the AllColumns schema collection has been added to support sparse columns. NO if the column is not a column set column.īeginning with the. 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. 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. 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.
0 Comments
Leave a Reply. |