Search
 
SCRIPT & CODE EXAMPLE
 

SQL

show column from sql server

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

show columns in sql

#MySQL
show columns from table_name
Comment

PREVIOUS NEXT
Code Example
Sql :: sqlserver docker 
Sql :: drop all procedures sql server 
Sql :: mysql limit offset 
Sql :: delete all content in table mysql 
Sql :: SQL Modify Column in a Table -Oracle 
Sql :: enable service broker in sql server 
Sql :: linebreak sql 
Sql :: sql server week number 
Sql :: sql where contains 
Sql :: mysql find missing values 
Sql :: postgres set default schema 
Sql :: SQL date part only of datetime 
Sql :: how to add CHECK constraint to a column in postgres 
Sql :: sql create table statement 
Sql :: add column with foreign key constraint sql server 
Sql :: postgres populate table from another table 
Sql :: sql convert xml to text 
Sql :: get server date mysql 
Sql :: calculate distance between two latitude longitude points sql 
Sql :: mysql concatenate null 
Sql :: oracle drop temporary table 
Sql :: how to get the date diff on once field in sql server 
Sql :: pl/sql cursor 
Sql :: mysql case when on date 
Sql :: mysql timediff 
Sql :: begin transaction sql 
Sql :: Mysql Create table with foreign keys. 
Sql :: join in update query in mysql 
Sql :: sql server select first day of previous year 
Sql :: mysql list tables by size 
ADD CONTENT
Topic
Content
Source link
Name
9+4 =