Search
 
SCRIPT & CODE EXAMPLE
 

SQL

get column name sql server

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'Customers'
Comment

get table column names sql

SELECT      COLUMN_NAME AS 'ColumnName'
FROM        INFORMATION_SCHEMA.COLUMNS 
WHERE 
TABLE_NAME LIKE '%assembly_armatureassy_tbl%' 
and COLUMN_NAME LIKE '%supplied%'
Comment

get column name list sql

EXEC sp_columns 'Your Table Name'
Comment
PREVIOUS NEXT
Code Example
Sql :: oracle list columns 
Sql :: select duplicates in sql 
Sql :: Duplicating a MySQL table with all the data Command 
Sql :: mysql CURRENT_TIMESTAMP() 
Sql :: mysql workbench download for iinux mint 19.3 
Sql :: this month mysql where 
Sql :: string to int mysql 
Sql :: sql not start with vowel 
Sql :: how to remove tables from postgresql 
Sql :: postgres alter user password 
Sql :: while loop sql 
Sql :: log queries postgre 
Sql :: postgres regex remove special characters 
Sql :: show indexes in mql 
Sql :: raise application error in oracle 
Sql :: mysql text to decimal 
Sql :: sqlite3 now 
Sql :: oracle show running job 
Sql :: get hour from date sql 
Sql :: top 10 rows in mysql 
Sql :: convert int to string in sql server 
Sql :: how to update an attribute in MySQL 
Sql :: second last highest id in sql 
Sql :: psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" f 
Sql :: show structure of table in sql 
Sql :: mysql id reset 
Sql :: mysql get count of rows 
Sql :: mysql show table column full description 
Sql :: copy all values of a column to another column in sql in same table 
Sql :: laravel migration sql dump 
ADD CONTENT
Topic
Content
Source link
Name
6+6 =