Aug 18, 2013 · In SQL Server, you can use this query: USE Database_name SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='Table_Name'; And do not …

Jun 7, 2017 · @schmijos: actually it's implied, at best. "sql" does NOT mean "MS Sql Server" and it's irritating that so many people seem to think it's acceptable to use the generic term to …

Feb 11, 2013 · Name and datatype: USE OurDatabaseName GO SELECT sc.name AS [Columne Name], st1.name AS [User Type], st2.name AS [Base Type] FROM dbo.syscolumns sc …

Feb 8, 2023 · To get the whole database structure as a set of CREATE TABLE statements, use mysqldump: mysqldump database_name --compact --no-data For single tables, add the table …

Sep 20, 2008 · 1) PostgreSQL DESCRIBE TABLE using psql. In psql command line tool, \d table_name or \d+ table_name to find the information on columns of a table. 2) PostgreSQL …

Mar 31, 2013 · SELECT COLUMN_NAME, DATA_TYPE FROM ALL_TAB_COLUMNS WHERE TABLE_NAME='your_table_name'; It's been a while since I've worked with Oracle though. …

Jun 4, 2017 · SQL query to get the structure of a table of datbaseA in serverA. 1. how to see the Table structure in the ...

Sep 30, 2009 · SHOW CREATE TABLE. The SHOW CREATE TABLE statement can be used to retrieve the CREATE TABLE statement to reproduce this table. For example: SHOW CREATE …

Nov 22, 2019 · DESC is an Oracle client command - works in SQLPlus, SQLcl, and SQL Developer - WHEN connected to an Oracle Database. The best we have to offer you is, open …

Apr 16, 2015 · The Db2 catalogs hold lots of information about table structure. You can query them to find (most) things out about the structure of a table. For example, you can generate …