Αποτελέσματα Αναζήτησης
29 Ιουλ 2010 · For Sybase aka SQL Anywhere the following command outputs the structure of a table: DESCRIBE 'TABLE_NAME';
11 Σεπ 2019 · To show the table structure with all its column’s attributes: name, datatype, primary key, default value, etc. In SQL Server, use sp_help function: sp_help [ [ @objname = ] table_name ] In MySQL and Oracle, you can use DESCRIBE: DESCRIBE table_name;
10 Μαΐ 2023 · So desc or describe command shows the structure of the table which include the name of the column, the data type of the column and the nullability which means, that column can contain null values or not.
2 Ιουλ 2024 · The syntax for the command is as follows: DESCRIBE table_name; Alternatively, you can use the shorter form of the command: DESC table_name; Executing this command will display the structure of the specified table. The output will include the column names, data types, and nullability of each column. For example: DESCRIBE employees;
SELECT s.name as schema_name, t.name as table_name, c.* FROM sys.columns AS c INNER JOIN sys.tables AS t ON t.object_id = c.object_id INNER JOIN sys.schemas AS s ON s.schema_id = t.schema_id WHERE t.name = 'mytable' AND s.name = 'dbo'; Related content. sys.columns (Transact-SQL) sys.tables (Transact-SQL) sys.schemas (Transact-SQL)
13 Οκτ 2022 · When we use the command DESC or DESCRIBE, it provides us with information about the organization and structure of a table. The output of this command includes six columns: field, type, null, key, default, and extra. The field column displays the names of the table's columns, while the type column shows the data type for each column.
27 Μαΐ 2024 · Following is the syntax to use INFORMATION_SCHEMA views to describe a table in SQL Server: Syntax: SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'table_name'; where: table_name: is the name of the table you want to describe. column_name: describes all the columns of the ...
