Precision radix of approximate numeric data, exact numeric data, integer data, or monetary data.
![sql datatype for an icollections sql datatype for an icollections](https://docs.appdynamics.com/download/attachments/41256423/specify-data-to-collect.png)
Precision of approximate numeric data, exact numeric data, integer data, or monetary data. 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.
![sql datatype for an icollections sql datatype for an icollections](https://d3njjcbhbojbot.cloudfront.net/api/utilities/v1/imageproxy/https://coursera-course-photos.s3.amazonaws.com/7a/569080aab711e79d97bf25c196049d/1200px-square-dark.jpg)
The type of the index will be one of the following:Ĭolumn name the index is associated with.
![sql datatype for an icollections sql datatype for an icollections](http://www.sql-articles.com/images/media/articles/pdw_part2_3.png)
Schema that contains the table the index is associated with. 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. The Microsoft SqlClient Data Provider for SQL Server supports additional schema collections in addition to the common schema collections.