Sql query to find column name in all tables

In SQL, sometimes we need to search the column names in a table using the prefixes. For this article, we will be using the Microsoft SQL Server as our database and Select keyword.

Step 1: Create a Database.

For this use the below command to create a database named GeeksForGeeks.

Query:

CREATE DATABASE GeeksForGeeks

Output:

Step 2: Use the GeeksForGeeks database.

For this use the below command.

Query:

USE GeeksForGeeks

Output:

Step 3: Create a table of EVALUATION inside the database GeeksForGeeks. This table has 6 columns namely STUDENT_NAME, STUDENT_ID, ENGLISH_MARKS, ENGLISH_PERCENTAGE, SCIENCE_MARKS, SCIENCE_PERCENTAGE containing the names and ids of students, their marks and percentages in English subject and their marks and percentages in Science subject.

Query:

CREATE TABLE EVALUATION( STUDENT_NAME VARCHAR(10), STUDENT_ID INT, ENGLISH_MARKS INT, ENGLISH_PERCENTAGE INT, SCIENCE_MARKS INT, SCIENCE_PERCENTAGE INT);

Output:

Step 4: Describe the structure of the table EVALUATION.

Query:

EXEC SP_COLUMNS EVA

sql get all columns in database

sql search all columns in database for string