SQL SERVER – Simple Way to Find Existence of Column in a Table
If you want to check if the column is already available in the table, you can use system views like sys.columns or INFORMATION_SCHEMA.COLUMNS. Let us create this dataset USE TEMPDB; CREATE TABLE TESTING(ID INT, NAME VARCHAR(100)) Suppose you want to find out the existence of the column named NAME and…
Read More