37

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

Error: User Rate Limit Exceeded

  • Error: User Rate Limit Exceeded

    от
  • Error: User Rate Limit Exceeded

    от
  • Error: User Rate Limit Exceeded

    от
12 ответов
  • 1

    Error: User Rate Limit Exceeded

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

  • 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

  • 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'
    

  • 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'
    

  • 4

    Error: User Rate Limit Exceeded

    SELECT column_name FROM user_tab_columns WHERE table_name = 'TABLENAME'
    

  • 1

    Error: User Rate Limit Exceeded

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

  • 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]')
    

  • 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 * from INFORMATION_SCHEMA.COLUMNS
    where table_name = '[table name]'
    

    sp_help

    sp_help '[table name]'