Sql

select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tableName'

#MySQL
show columns from table_name

-- sql server 
sp_columns feeAgreement
-- or
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'feeAgreement'

PREVIOUS	NEXT

Code Example
Sql :: convert date to datetime sql
Sql :: ORA-00903
Sql :: sql insert inserted id
Sql :: How to convert Varchar to Double in sql?
Sql :: set column to not null mysql
Sql :: how to remove a column from a table in MySQL
Sql :: enable service broker in sql server
Sql :: convert rows to columns in sql server
Sql :: ubuntu mysql cannot connect to database server remote
Sql :: mysql concatenate select results
Sql :: trigger in postgresql to change incoming entry
Sql :: postgresql alter table sequence
Sql :: table or view does not exist
Sql :: sql server substring
Sql :: update single sql column
Sql :: mysql inner join 3 tables
Sql :: oracle drop index if exists
Sql :: mysql regex replace
Sql :: sql count group by
Sql :: regex mongoose
Sql :: postgres statistics
Sql :: update using case in mysql
Sql :: sqlite data types
Sql :: drop df constraint sql server
Sql :: SQL Modify Column in a Table -MySQL
Sql :: datediff
Sql :: t sql null or empty string
Sql :: sql select into statement
Sql :: postgresql size of database
Sql :: windows services sql