how to get table and column names in sql server code example
Example 1: How to View column names of a table in SQL
DESCRIBE Table_Name;
OR
DESC Table_Name;
Example 2: sql query to get column names and data types in sql server
SELECT COLUMN_NAME,
DATA_TYPE,
IS_NULLABLE,
CHARACTER_MAXIMUM_LENGTH,
NUMERIC_PRECISION,
NUMERIC_SCALE
FROM 'your_database_name'.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='your_table_name';