Experts Exchange Solution brought to you by
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
SELECT T.name AS TableName, C.name AS ColumnName
FROM sys.tables AS T
INNER JOIN sys.columns AS C
ON C.object_id = T.object_id
WHERE T.name = 'RefPrefix'
AND C.name = 'Code2'
Open in new window
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Public Shared Function ColumnExists(ByVal tableName As String,
ByVal columnName As String,
ByVal conn As SqlClient.SqlConnection) As Boolean
Dim strSQL As String = "SELECT COUNT(*) FROM information_schema.columns " & _
"WHERE table_schema = 'dbo' " & _
"AND table_name = '" & tableName & "'" & _
"AND column_name = '" & columnName & "';"
Using cmd As New SqlClient.SqlCommand(strSQL, conn)
Dim bExists As Boolean
Using conn As New SqlClent.SqlConnection(YourConnectionStringHere)
bExists = ColumnExists(YourTableName, YourColumnName, conn)
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.