Sql

SELECT column_name, data_type, character_maximum_length
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name ='table_name';

PREVIOUS	NEXT

Code Example
Sql :: t-sql test if table exists
Sql :: MySQL - Enabling the Event Scheduler
Sql :: mysql count words
Sql :: oracle check table space
Sql :: sql drop primary key
Sql :: key validation sql
Sql :: command line mysql import
Sql :: second last highest id in sql
Sql :: how to give user privelege to create dblink in oracle
Sql :: mysql date greater than 30 days
Sql :: how to add unique constraint in mysql table
Sql :: mysql date diff in seconds
Sql :: reset auto increment in sql
Sql :: mysql calculate age
Sql :: psql restore from tar
Sql :: mysql get count of rows
Sql :: oracle sql drop table
Sql :: show per page table in xampp
Sql :: oracle export trigger ddl
Sql :: set password mysql
Sql :: apex ORA-20999
Sql :: mysql find non alphanumeric characters
Sql :: how to get ddl for materialized view
Sql :: mssql cursor
Sql :: last 6 months postgresql
Sql :: add days in oracle sql
Sql :: update set with inner join oracle
Sql :: postgresql get year
Sql :: what is initial catalog in sql connection string
Sql :: run mysql xampp shell