Differences

This shows you the differences between two versions of the page.

--- vendors:microsoft:sql [2024/12/06 13:52] – [Parsing a string with a separator] gerardorourke
+++ vendors:microsoft:sql [2026/04/28 14:24] (current) – [Column types] gerardorourke
@@ Line 369: / Line 369: @@
 	MFA|2|boo|6:2	MFA|2|boo|6	MFA	2	boo	6
 	MFA|3|boo|7:3	MFA|3|boo|7	MFA	3	boo	7
+</code>
+==== Get SQL Column Data TYPE ====
+<code sql>
+SELECT
+    COLUMN_NAME,
+    DATA_TYPE,
+    CHARACTER_MAXIMUM_LENGTH
+FROM INFORMATION_SCHEMA.COLUMNS
+WHERE TABLE_NAME = 'YourTableName';
+</code>
+==== Check if Column is a primary Key====
+<code sql>
+SELECT
+    kcu.COLUMN_NAME
+FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc
+JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu
+    ON tc.CONSTRAINT_NAME = kcu.CONSTRAINT_NAME
+WHERE tc.TABLE_NAME = 'YourTableName'
+  AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY'
+  AND kcu.COLUMN_NAME = 'agentId';
 </code>