37

Вопрос по database, mysql, sql-server, sql – Что такое команда SQL для возврата имен полей таблицы?

Error: User Rate Limit Exceeded

12 ответов
0

Error: User Rate Limit Exceeded describe tablename

Error: User Rate Limit Exceeded

describe tablename
2

Error: User Rate Limit Exceeded show fields from [tablename];

Error: User Rate Limit Exceeded

show fields from [tablename];

Error: User Rate Limit Exceeded

1

Error: User Rate Limit Exceeded

select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'tablename'
3

Error: User Rate Limit Exceeded

pragma table_info()

sqlite> pragma table_info('table_name');
cid         name        type        notnull     dflt_value  pk        
----------  ----------  ----------  ----------  ----------  ----------
0           id          integer     99                      1         
1           name                    0                       0         
1

Error: User Rate Limit Exceeded

select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'tablename'

sp_help 'tablename'
1

Error: User Rate Limit Exceeded

SELECT TABNAME,COLNAME from SYSCAT.COLUMNS where TABNAME='MYTABLE'
2

Error: User Rate Limit Exceeded

select c.column_name from systabcol c 
       key join systab t on t.table_id=c.table_id 
       where t.table_name='tablename'
4

Error: User Rate Limit Exceeded

select column_name from information_schema.columns where table_name = 'myTable'

\d myTable

4

Error: User Rate Limit Exceeded

SELECT column_name FROM user_tab_columns WHERE table_name = 'TABLENAME'
58

Error: User Rate Limit Exceeded desc tablename

Error: User Rate Limit Exceeded

desc tablename

Error: User Rate Limit Exceeded

show fields from tablename

Error: User Rate Limit Exceeded

select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS 
where TABLE_NAME = 'tablename'

Error: User Rate Limit Exceededsp_help

exec sp_help 'tablename'

Error: User Rate Limit Exceeded

от 

Error: User Rate Limit Exceeded

от 

Error: User Rate Limit Exceeded

от 
11

Error: User Rate Limit Exceeded

select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'myTable'

exec sp_help 'myTable'

select [name] from dbo.syscolumns where id = object_id(N'[dbo].[myTable]')
4

Error: User Rate Limit Exceeded

select * from INFORMATION_SCHEMA.COLUMNS
where table_name = '[table name]'

sp_help

sp_help '[table name]'

Похожие вопросы