Display the Table Structure Using the Sql Describe Operation
SQL DESC Statement Describe Table SQL DESC statement use for describe the list of column definitions for specified table. For a list of tables in the current schema use the Show Tables command. Sql Describe Table Structure Stack Overflow Using SQL Server Management Studio. . SQL Server table structure overview. Create table one id int not null name char25 city varchar225 Step 2. DESCRIBE statement to get following information. Defining structure of table ie Creating a table. Column Name Column allow NULL or NOT NULL Datatype of the Column. Sp_help table_name or sp_columns table_name for only columns Oracle DB2. Show activity on this post. The simplest way to use sp_columns to show the columns and related information about a SQL Server table is to execute the stored proecedure passing it the table name like so. Select from ALL_CONSTRAINTS where TABLE_NAME MY_TABLE and CONSTRAINT_TYPE. The t...